Excel Macros option greyed out

[Andy M]

A user I support is launching excel from another application.

the problem he has is that the Macro option on the tools menu is greyed
out... any ideas what has caused this ?

 

[BobC]

Just a thought...

This could be by design - try starting Excel with no macros running.

As Excel launches hold down the shift key and any automatic macros will not
run.

BobC

 

[Andy M]

The user has transferred a recently created file to his machine from the
version of excel he was running through citrix.

Even though the file is now locally on his pc, the Macro option is still
greyed out.

So it looks like there is some setting stored within the worksheet.

comments ? / help ?