enable macros question not being asked when opening file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Disable Macro Alert 2
Macro-enabled workbooks 1
security med-but still wont open with macros 1
Macro security 6
Macros in Excel2007 5
EXCEL 2007 Macro Security Being Ignored 9
File opens with Enable or Disable Macro 1
Excel files - macros & links 4

Back
Top