Macros always run
When you disable macros with the security prompt not all macros are disable: you can start macros call by shorcuts key. How can you disable all kind of macros?
-- Message posted via http://www.officekb.com |
Macros always run
Regis
That's not correct. All macros are disabled. Are you sure that you don't have 2 instances of that same file running at the same time? HTH Otto "Regis Banville via OfficeKB.com" wrote in message ... When you disable macros with the security prompt not all macros are disable: you can start macros call by shorcuts key. How can you disable all kind of macros? -- Message posted via http://www.officekb.com |
Macros always run
My macros are on a XLA sheet. Is it possible that the macros are allways available?
-- Message posted via http://www.officekb.com |
Macros always run
Regis
An add-in(*.xla) is not subject to the same rules as a workbook(*.xls) when it comes to disabling macros. You will not get the macro warning or the option to disable macros in the Add-in when an *.xla loads. Gord Dibben Excel MVP On Sun, 19 Dec 2004 14:56:38 GMT, "Regis Banville via OfficeKB.com" wrote: My macros are on a XLA sheet. Is it possible that the macros are allways available? |
Macros always run
This is true if the .xla is in XLStart or added in Tools|Addins.
But if I just open the addin via file|open (or double clicking on it in windows explorer), I get prompted about the macros. Gord Dibben wrote: Regis An add-in(*.xla) is not subject to the same rules as a workbook(*.xls) when it comes to disabling macros. You will not get the macro warning or the option to disable macros in the Add-in when an *.xla loads. Gord Dibben Excel MVP On Sun, 19 Dec 2004 14:56:38 GMT, "Regis Banville via OfficeKB.com" wrote: My macros are on a XLA sheet. Is it possible that the macros are allways available? -- Dave Peterson |
Macros always run
Not having occasion/reason recently to open an Add-in in that manner, I did
not remember this. Thanks Dave for update. Gord On Sun, 19 Dec 2004 15:48:36 -0600, Dave Peterson wrote: This is true if the .xla is in XLStart or added in Tools|Addins. But if I just open the addin via file|open (or double clicking on it in windows explorer), I get prompted about the macros. Gord Dibben wrote: Regis An add-in(*.xla) is not subject to the same rules as a workbook(*.xls) when it comes to disabling macros. You will not get the macro warning or the option to disable macros in the Add-in when an *.xla loads. Gord Dibben Excel MVP On Sun, 19 Dec 2004 14:56:38 GMT, "Regis Banville via OfficeKB.com" wrote: My macros are on a XLA sheet. Is it possible that the macros are allways available? |
All times are GMT +1. The time now is 01:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com