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

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
"Dash" wrote in message
...
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