Opening a file without the macro start menu

[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

 

[Roman]

Hi Fernando,
you will need to change your security level to low:
Tools / macro / security

 

[Fernandoalberte]

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

 

[Bob Phillips]

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"

 

[Roman]

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?

 

[bhawane]

create a digital certificate, then use this as a trusted source