ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel 2002 Macro Run button disabled? (https://www.excelbanter.com/excel-programming/276920-excel-2002-macro-run-button-disabled.html)

Dash

Excel 2002 Macro Run button disabled?
 
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



Suzette

Excel 2002 Macro Run button disabled?
 
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






All times are GMT +1. The time now is 05:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com