ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   open file with macros disable (https://www.excelbanter.com/excel-programming/435441-open-file-macros-disable.html)

Alberto Ast[_2_]

open file with macros disable
 
Need to open a file2 from a macro on file1 to pull some data but need file2
opened with macros disable... but maintain file1 macros anable.

file1 macros anable
file2 macros disable while openeing the file

How can I do it?

Barb Reinhardt

open file with macros disable
 
See response to other post. It does what you want.

"Alberto Ast" wrote:

Need to open a file2 from a macro on file1 to pull some data but need file2
opened with macros disable... but maintain file1 macros anable.

file1 macros anable
file2 macros disable while openeing the file

How can I do it?



All times are GMT +1. The time now is 02:59 PM.

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