Drop Down Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Greetings,
I have an Excel doc with drop down boxes from the control toolbox. I was
able to affect the properties of these boxes by right clicking on them and
going ino the dialogue box for formatting the controls.
Now when I try to do it, it doesn't give me the right click menu. Is there
some method in Excel to reactivate the right click menu on these controls?
Perhaps some sort of template mode? Thank you.
Rod
 
You can try this:
Press Alt+F11
Press Ctrl+G
Type this into the pane that appears at the bottom of the Window and press
Enter:
Application.CommandBars("Cell").Enabled = True

tj
 
Disregard my previous post--that's not going to work.

What you may check for is whether or not yp are in Design Mode.
Bring up the Control Toolbox and click on the Design Mode button, if it's
not activated. It's usually first on the toolbar.

tj
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to delete a drop down box in Excel 2007 1
Can't find the properties in a Combo Box 2
How to Display Arrow for Drop Down Lists in Message Body 0
Auto filter drop down box 1
Drop Down--How do I copy and update cell link/input range 1
drop down box 1
Excel Drop Down Box 2
drop down menu autocomplete 1

Back
Top