Opening a file without the macro start menu
 

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


--
Fernandoalberte
------------------------------------------------------------------------
Fernandoalberte's Profile: http://www.excelforum.com/member.php...o&userid=24493
View this thread: http://www.excelforum.com/showthread...hreadid=383068

Opening a file without the macro start menu
 

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

Opening a file without the macro start menu
 

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

--
Fernandoalbert
-----------------------------------------------------------------------
Fernandoalberte's Profile: http://www.excelforum.com/member.php...fo&userid=2449
View this thread: http://www.excelforum.com/showthread.php?threadid=38306

Opening a file without the macro start menu
 

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"
<Fernandoalberte.1re2ql_1120050381.6408@excelfor um-nospam.com wrote in
message news:Fernandoalberte.1re2ql_1120050381.6408@excelf orum-nospam.com...

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 want
them to get this message. Is there anyway aroudn this?

Cheers

Fernando


--
Fernandoalberte
------------------------------------------------------------------------
Fernandoalberte's Profile:
http://www.excelforum.com/member.php...o&userid=24493
View this thread: http://www.excelforum.com/showthread...hreadid=383068

Opening a file without the macro start menu
 

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?

Opening a file without the macro start menu
 

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

--
bhawanePosted from http://www.pcreview.co.uk/ newsgroup acces