| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Opening a file without the macro start menu
Hi Fernando,
you will need to change your security level to low: Tools / macro / security |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro Folder Not Opening on Start Up | Excel Discussion (Misc queries) | |||
| Start Excel Macro upon opening of document | Excel Programming | |||
| macro to start on workbook opening | Excel Discussion (Misc queries) | |||
| start Macro when file is open | Excel Programming | |||
| start a macro when file opens?? | Excel Programming | |||
Hybrid Mode
