enable macros question not being asked when opening file

A

Aussie Ells

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?
 
G

Gord Dibben

Check under Help>About MS Excel>Disabled 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
 
Top