Opening a file without the macro start menu

  • Thread starter Thread starter Fernandoalberte
  • Start date Start date
F

Fernandoalberte

Guys,

When you open an excel file which has VB code in it, you are asked
(depening on your macro security settings) if you would like to disable
or enable macros.

Is there a way (perhaps via the auto_open code to stop this message
popping up and automatically enabling these macros?

Look forward to hearing your thoughts.

Regards,

Fernando
 
Hey there,

Sorry perhaps i was not clear in my explanation, i apologise

I am creating a file, and when OTHER people open the file i don't wan
them to get this message. Is there anyway aroudn this?

Cheers

Fernand
 
You either change their security settings (Bad Idea!), or put the code in an
add-in and install it, or live with it.

--
HTH

Bob Phillips

"Fernandoalberte"
 
Then they will have to change the security level.
If there was a way around this the excel security wuldn't be much goog
don't you think?
 
Back
Top