Excel 2002 Macro Run button disabled?

D

Dash

I have a workbook with a vba code module.
The macro is currently initiated from Tools, macro, macros, Run.
On several PCs Win2k, WinXP, Excel 9 and Excel 10
it runs fine.
On one PC (the customers and a long way away) Win2k, Excel 10, the macro Run
button shows as 'disabled' (grayed out).

Anyone got a clue as to what setting on that PC would cause this to happen?

TIA

Dash
 
S

Suzette

Do they have their settings on Excel to disable macros automatically? They
might have their macro security set to high. They need to either set it
lower (so it will either run or it will ask them) or set you up as a trusted
source.

Sue
 

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

Need Help with Macro Security 1
How to call Excel add-in macro from a button… 1
Disabled VB Editor Button and Macro Buttons 4
Excel buttons change macro file name when run on other computers 7
Second run of macro hangs on .show of application.filedialog object! 3
VBA code won't run, even with Macro Security set to Enable All Macors 9
security, enabling macros to enable a disabling saving function 12
Macros disabled, not by security settings? 9

Top