View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Command/option/spin button - no control menu available

Sounds like you are using controls from the Forms toolbar rather than the
Control Toolbox toolbar. Try using the Control Toolbox Toolbar to achieve
your previous functionality.

--
Regards,
Tom Ogilvy

"Daniel" wrote in message
...
Hi

Since I updated my Excel 2000 with the new services
packages, I cannot access the "assign macro" or open
the "control" menu (via right mouse click/Format control)
when inserting a command, option or spin button.

Previously, it was pretty easy to use these buttons and a
macro was not necessary. When I inserted a button, I right-
clicked and chose "Format control". The windows which
appeared contained 5 tabs(Size, Protect, Properties, Web,
Control). Now, the control tab is not there anymore.

To use this functions know, I have to go in an old
worksheet, copy a button and insert it on the new
worksheet. This is inconvenient and time consuming.

May anybody help me and knows what I have to do?

Thank you very much

Daniel