Excel 2003 - macro options grayed-out

J

Jarek Kujawa

Hi,
in one file macro options button is active, in another the button is
grayed-out.

How to make that button always active?
(I know there is other ways to assign a key shortcut programmatically
like MacroOptions and OnKey methods, but they are not what I'm looking
for)

TIA
 
J

Joel

The workbook probably has a macro that is running when the workbook is opened
that is disabling the menu option. Try using Alt-F11 to see if you can get
to the VBA menu. The VBA Project may be protected with a password that won't
allow you to make changes.
 
J

Jarek Kujawa

exactly!
I have a Workbook-Open procedure
did noit think thia might have been a couse
thanks!
this solves the problem!
 

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

Assign different keyboard shortcuts 4
Button Click but not Shortcut Key 1
delete button is grayed out 2
Assign macro to WB-specific toolbar button? 6
OnKey - usable to assign new shortcuts to existing Excel keyboardshortcuts? 2
Need to copy macros and Organizer is grayed out 3
Access Import & Link section grayed out MS Access 2010 1
Conditional application.onkey in realtime? 2

Top