ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macros always run (https://www.excelbanter.com/excel-programming/319257-macros-always-run.html)

Regis Banville via OfficeKB.com

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

Otto Moehrbach[_6_]

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




Regis Banville via 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

Gord Dibben

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?



Dave Peterson[_5_]

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

Gord Dibben

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