ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Open workbook without running Macros (https://www.excelbanter.com/excel-programming/362610-open-workbook-without-running-macros.html)

Raul[_2_]

Open workbook without running Macros
 
How can I manually open a workbook without the running macros that are set to
run when the workbook is opened?

Thanks in advance,
Raul


Dave Peterson

Open workbook without running Macros
 
You can change the security level to high (or medium and say no to the allow
macro prompt) to turn off all macros in that workbook (open the workbook after
you toggle this setting--it's not retroactive).

Or you could hold the shift key down while opening the file. This stops the
auto_open and workbook_open events, but doesn't disable all the macros (if you
need them later).

Raul wrote:

How can I manually open a workbook without the running macros that are set to
run when the workbook is opened?

Thanks in advance,
Raul


--

Dave Peterson

Raul[_2_]

Open workbook without running Macros
 
Holding the shift key down while opening the file is exactly the type of
solution I was looking for.

Thank you very much,
Raul

"Dave Peterson" wrote:

You can change the security level to high (or medium and say no to the allow
macro prompt) to turn off all macros in that workbook (open the workbook after
you toggle this setting--it's not retroactive).

Or you could hold the shift key down while opening the file. This stops the
auto_open and workbook_open events, but doesn't disable all the macros (if you
need them later).

Raul wrote:

How can I manually open a workbook without the running macros that are set to
run when the workbook is opened?

Thanks in advance,
Raul


--

Dave Peterson



All times are GMT +1. The time now is 11:37 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com