A Alan T Nov 16, 2003 #1 Is it possible to remove the Disable/Enable Macros screen when document loads
C Chip Pearson Nov 16, 2003 #2 Alan, You can't disable the macro warning for a document. If you could, then any self-respecting virus would do exactly that. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
Alan, You can't disable the macro warning for a document. If you could, then any self-respecting virus would do exactly that. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
A Alan T Nov 16, 2003 #3 That's kinda what I thought. Another quick question then... is it possible to change the butto default onto the enable macro option?
That's kinda what I thought. Another quick question then... is it possible to change the butto default onto the enable macro option?
P Paddy Nov 16, 2003 #4 If you want to remove the disabel / enable macros screen. You can - 1) Change security settings in excel to low. Tools / Macro / Security / Low or better / safer ... 2) Digitally sign the macro(s) so that it is from a trusted source and leave security settings (above) at High or Medium. That's what I use.
If you want to remove the disabel / enable macros screen. You can - 1) Change security settings in excel to low. Tools / Macro / Security / Low or better / safer ... 2) Digitally sign the macro(s) so that it is from a trusted source and leave security settings (above) at High or Medium. That's what I use.
A Alan T Nov 17, 2003 #5 How do I digitally sign the macros? *If you want to remove the disabel / enable macros screen. You can - 1) Change security settings in excel to low. Tools / Macro / Security / Low or better / safer ... 2) Digitally sign the macro(s) so that it is from a trusted source and leave security settings (above) at High or Medium. That's what I use. Click to expand...
How do I digitally sign the macros? *If you want to remove the disabel / enable macros screen. You can - 1) Change security settings in excel to low. Tools / Macro / Security / Low or better / safer ... 2) Digitally sign the macro(s) so that it is from a trusted source and leave security settings (above) at High or Medium. That's what I use. Click to expand...
A Alan Nov 17, 2003 #6 I think this only happens in later XL2002 onwards but I may be wrong. If you're using this version Tools > Macro's and the explanation is there,
I think this only happens in later XL2002 onwards but I may be wrong. If you're using this version Tools > Macro's and the explanation is there,
