| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Enable Macro Alert Box
Hi.
Is there a way, you can turn off the warning regarding macros when you opena file that contaons one. I know the file has macros in it as i created it, but is there a way to get excel to stop forever telling me and giving me 3 options everytime i open the file such as diable, enable, and more info. Is there a way to turn this feature off full stop. Many Thanks for your help as always all. MattLynn -- Matt Lynn Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200909/1 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Enable Macro Alert Box
Hi,
Tools Options Security Macro Security Low -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Mattlynn via OfficeKB.com" <u44078@uwe wrote in message news:9c8dfab1da6ac@uwe... Hi. Is there a way, you can turn off the warning regarding macros when you opena file that contaons one. I know the file has macros in it as i created it, but is there a way to get excel to stop forever telling me and giving me 3 options everytime i open the file such as diable, enable, and more info. Is there a way to turn this feature off full stop. Many Thanks for your help as always all. MattLynn -- Matt Lynn Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200909/1 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Enable Macro Alert Box
Brilliant - Thanks.
I guessed it was something easy like that Many Thanks again Regards Matt Ashish Mathur wrote: Hi, Tools Options Security Macro Security Low Hi. Is there a way, you can turn off the warning regarding macros when you [quoted text clipped - 11 lines] Many Thanks for your help as always all. MattLynn -- Matt Lynn Message posted via http://www.officekb.com |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Enable Macro Alert Box
You are welcome.
-- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Ashish Mathur" wrote in message ... Hi, Tools Options Security Macro Security Low -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Mattlynn via OfficeKB.com" <u44078@uwe wrote in message news:9c8dfab1da6ac@uwe... Hi. Is there a way, you can turn off the warning regarding macros when you opena file that contaons one. I know the file has macros in it as i created it, but is there a way to get excel to stop forever telling me and giving me 3 options everytime i open the file such as diable, enable, and more info. Is there a way to turn this feature off full stop. Many Thanks for your help as always all. MattLynn -- Matt Lynn Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200909/1 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Enable Macro Alert Box
ToolsMacroSecuritySecurity Level and set it as Low.
If this post helps, Click Yes! -------------------- (MS-Exl-Learner) -------------------- "Mattlynn via OfficeKB.com" wrote: Hi. Is there a way, you can turn off the warning regarding macros when you opena file that contaons one. I know the file has macros in it as i created it, but is there a way to get excel to stop forever telling me and giving me 3 options everytime i open the file such as diable, enable, and more info. Is there a way to turn this feature off full stop. Many Thanks for your help as always all. MattLynn -- Matt Lynn Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200909/1 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Enable Macro Alert Box
Brilliant - Thanks.
I guessed it was something easy like that Many Thanks again Regards Matt Ms-Exl-Learner wrote: ToolsMacroSecuritySecurity Level and set it as Low. If this post helps, Click Yes! -------------------- (MS-Exl-Learner) -------------------- Hi. Is there a way, you can turn off the warning regarding macros when you opena [quoted text clipped - 8 lines] Many Thanks for your help as always all. MattLynn -- Matt Lynn Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200909/1 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Enable Macro Alert Box
If just for your own use have a look at creating a digital signature using
the MS Office selfcert tool. Sign your book and get rid of the message without compromising security. Gord Dibben MS Excel MVP On Wed, 23 Sep 2009 15:49:43 GMT, "Mattlynn via OfficeKB.com" <u44078@uwe wrote: Hi. Is there a way, you can turn off the warning regarding macros when you opena file that contaons one. I know the file has macros in it as i created it, but is there a way to get excel to stop forever telling me and giving me 3 options everytime i open the file such as diable, enable, and more info. Is there a way to turn this feature off full stop. Many Thanks for your help as always all. MattLynn |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Enable Macro Alert Box
Agreed with Gord on this one, lowering your security is a bad idea,
you might forget and then open another macro-enabled workbook that could damage your computer and you would have no way to stop it. A digital signature for your personal projects is a better idea. --JP On Sep 23, 4:46*pm, Gord Dibben <gorddibbATshawDOTca wrote: If just for your own use have a look at creating a digital signature using the MS Office selfcert tool. Sign your book and get rid of the message without compromising security. Gord Dibben *MS Excel MVP On Wed, 23 Sep 2009 15:49:43 GMT, "Mattlynn via OfficeKB.com" <u44078@uwe wrote: Hi. Is there a way, you can turn off the warning regarding macros when you opena file that contaons one. I know the file has macros in it as i created it, but is there a way to get excel to stop forever telling me and giving me 3 options everytime i open the file such as diable, enable, and more info. Is there a way to turn this feature off full stop. Many Thanks for your help as always all. MattLynn- Hide quoted text - - Show quoted text - |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Enable Macro Alert Box
Thanks Gordon - that seems like an interesting way round the problem.
I shall check this out too. Many Thank for helpingRegards Matt Gord Dibben wrote: If just for your own use have a look at creating a digital signature using the MS Office selfcert tool. Sign your book and get rid of the message without compromising security. Gord Dibben MS Excel MVP Hi. Is there a way, you can turn off the warning regarding macros when you opena [quoted text clipped - 8 lines] Many Thanks for your help as always all. MattLynn -- Matt Lynn Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200909/1 |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Enable Macro Alert Box
Thanks Gordon - that seems like an interesting way round the problem.
I shall check this out too. Many Thank for helpingRegards Matt Gord Dibben wrote: If just for your own use have a look at creating a digital signature using the MS Office selfcert tool. Sign your book and get rid of the message without compromising security. Gord Dibben MS Excel MVP Hi. Is there a way, you can turn off the warning regarding macros when you opena [quoted text clipped - 8 lines] Many Thanks for your help as always all. MattLynn -- Matt Lynn Message posted via http://www.officekb.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| security alert on macro-enabled worksheet | Excel Discussion (Misc queries) | |||
| Excel Macro Alert | Excel Discussion (Misc queries) | |||
| Enable macro | Excel Discussion (Misc queries) | |||
| How do I enable a macro? | Excel Discussion (Misc queries) | |||
| how to enable macro | Excel Worksheet Functions | |||
Hybrid Mode
