enable macros question not being asked when opening file
 

I have a file with numerous vba functions. I recently copied the file to
model a different scenario but when I open the copied file I am not being
asked to "enable Macros", the file is just opening up straight away.

My macro security is still set to Medium but now when the file opens up all
my macros appear to be disabled and I get #Name? outputs in the cells
utilizing the vba functions.

Any idea what I've done AND how I fix it?

enable macros question not being asked when opening file
 

Check under HelpAbout MS ExcelDisabled Items.

Maybe something in there to re-enable.

Why Excel would choose to disable if that's the case......??

Maybe you started up one time in Safe Mode?


Gord Dibben MS Excel MVP



On Wed, 6 Jun 2007 19:41:01 -0700, Aussie Ells <Aussie
wrote:

I have a file with numerous vba functions. I recently copied the file to
model a different scenario but when I open the copied file I am not being
asked to "enable Macros", the file is just opening up straight away.

My macro security is still set to Medium but now when the file opens up all
my macros appear to be disabled and I get #Name? outputs in the cells
utilizing the vba functions.

Any idea what I've done AND how I fix it?