Pop Up Warning Macro Message

Parra · Apr 8th, 2002, 04:47 PM

Is there any way to eliminate the pop up Warning message, when I send someone a workbook with a macro. The message pops up when they click to open the workbook.

Thanks

Jack in the UK · Apr 8th, 2002, 04:55 PM

Hi

very very common question i would sufggest search this site as well documented.

BUT...

set macro ewarning to lo this will stop the message as wkbk opened, I DO NOT RECOMEND THIS AS ITS A WARNING TO CHECK SOURCE AND SHOULD YOU OPEN

also buy a signature from MSoft to digital sign the WkBk so will open

thats about it...
a pain but i say valid evil as if you on LAN should all ok but Email of floppy.. be careful

hope that some comfort we all suffer at other nasty ideas...

Ian Mac · Apr 8th, 2002, 04:57 PM

Unfortunately no.
there is an option under Tools>Option BUT this is reset at the network level by administrators.

The reason why not is that a lot of viruses are passed around like this (well, lets face it there are viruses).

Sorry!

Apr 8th, 2002, 04:55 PM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	Hi very very common question i would sufggest search this site as well documented. BUT... set macro ewarning to lo this will stop the message as wkbk opened, I DO NOT RECOMEND THIS AS ITS A WARNING TO CHECK SOURCE AND SHOULD YOU OPEN also buy a signature from MSoft to digital sign the WkBk so will open thats about it... a pain but i say valid evil as if you on LAN should all ok but Email of floppy.. be careful hope that some comfort we all suffer at other nasty ideas... __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Apr 8th, 2002, 04:57 PM	#3
Ian Mac MrExcel MVP Join Date: Feb 2002 Location: Newcastle, UK Posts: 1,174	Unfortunately no. there is an option under Tools>Option BUT this is reset at the network level by administrators. The reason why not is that a lot of viruses are passed around like this (well, lets face it there are viruses). Sorry! __________________ "Have a good time......all the time" Ian Mac

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 8th, 2002, 04:47 PM	#1
Parra Board Regular Join Date: Feb 2002 Location: Los Angeles, CA Posts: 752	Is there any way to eliminate the pop up Warning message, when I send someone a workbook with a macro. The message pops up when they click to open the workbook. Thanks