Remore open a macro enabled excel file without running macros

[SeniorTom]

I have 2 files 1.xlsm and 2.xlsm. Both have instruction messages when they are opened. when 1.xlsm opens 2.xlsm it is only using it for the data in the spreadsheet cells and doesn't need the open message or enable any macros. Is there a way to bypass the open message, the "the workbook contains links..." or "enable Macro" messages. I'm using "Workbooks.Open" to open it.

Regards
Tom

 

[BrianJN1]

Open the VBA editor in the file that you need to modify, double-click on ThisWorkBook to open up the macro text.
You can then delete the text.

 

[SeniorTom]

I may not have been clear.

2.xlsm, when being loaded, needs the macro so the user knows how to enter data and run the macro with a double click. After it is loaded by the user, 1.xlsm uses the data that had been loaded int 2.xlsm and fills in cells on 1.xlsm. It doesn't need to see the messages and use the macros. The macros can't be deleted because 2.xlsm will be updated again by the user.

 

[daverunt]

Still not entirely clear but see this link for the links update suppression.

Disable "update links message" when opening MS Excel via VBA Macro - Stack Overflow
Not sure you can bypass the enable macros notice other than changing the security or setting the file location as trusted. But that is only applicable to your PC.

 

[Fluff]

Hia
try

Application.EnableEvents = False
Workbooks.Open Filename:="######"
Application.EnableEvents = True

 

[SeniorTom]

Fluff,

Thanks, perfect, just what the doctor ordered

Tom

 

[Fluff]

Glad to help & thanks for the feedback