cannot view control properties in Excel form

[KellyK]

Hi all, I have been given a task to update an Excel form with some new information for the coming year, including adding a few controls based on new requirements. The person who designed this Excel app is no longer with the company. None of the spreadsheets are protected as far as I can tell, but for the life of me I cannot view the control properties! If I am in design view and click on, for instance, a list box, I then click "Properties" (in the Control toolbox) and the properties for the entire sheet come up. If I am on a control and right click, I do not get the menu for a control, but rather the menu as if I clicked on an empty cell. Is this some kind of protection the last developer put onto the book, and if so, is there any way to "undo" it? Thanks!

Kelly

 

[GlennUK]

Are you sure that the controls are Control Toolbox objects? Maybe they are Forms toolbar objects?

Make sure that the spreadsheet is unprotected, then right-click the control, and tell us exactly what the short-cut menu options are.



Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[KellyK]

Quite honestly, I am not sure if they are Control Toolbox objects, Form toolbar objects or some other type of object. The spreadsheet is definitely unprotected. Right clicking the control gives me the menu options that a regular, empty cell in Excel gives:

Cut, Copy, Paste, Paste Special, Insert, Delete, Clear Contents, Insert Comment, Format Cells, Pick from List, Hyperlink.

This is in design mode. For kicks, I added my own Form combo box and the look and feel is much different, giving me little white boxes to size the object and a completely different menu list consisting of Cut, Copy, Paste, Grouping, Order, Assign Macro, Format Control.

My fear is that, not only can I not see the properties of these "controls" that my predecessor designed, but that if I use a regular control toolbox object or a Form toolbar object it will not work as needed. This is for an Excel app that will be put on our company's intranet. I am very green with developing Excel apps (I usually work in Access), so any ideas are most appreciated!

Kelly

 

[KellyK]

D'oh! It's simply Data Validation. Here I was looking for something fancy....

Kelly

 

[SkipVought]

Kelly,

Exactly what KIND of a control are you referring to? There are 4 kinds of drop downs

Skip,

_{When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...
Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen!}

 

[KellyK]

Skip,
It was a regular Excel cell, no control at all, the "list" appears because the cell has Data Validation on it.

Kelly

 

[SkipVought]

"Is this some kind of protection the last developer put onto the book, and if so, is there any way to "undo" it?"


Select the cells containing Data Valudation.

Data > Validation - Clear All

Skip,

_{When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...
Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen!}

 

[KellyK]

Thanks, Skip!

Kelly