D
DMc2005
I know how to open a workbook using VBA, but how do i open a workbook and
disable its macros.
D
disable its macros.
D
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
R. Choate
First, just open Excel by itself and disable macros (Tools>Macros>Security, etc.). Then open the workbook with the macros you don't
want to run.
HTH
--
RMC,CPA
I know how to open a workbook using VBA, but how do i open a workbook and
disable its macros.
D
want to run.
HTH
--
RMC,CPA
I know how to open a workbook using VBA, but how do i open a workbook and
disable its macros.
D
G
Gary''s Student
D
DMc2005
I am running a macro from a file that opens several other files and enters
data into these files. however these files have macros in them.
so essentially i need to keep macros in my main workbook. but disable the
macros in the other workbooks. i cannot rely on users clicking disable
macros.
D
data into these files. however these files have macros in them.
so essentially i need to keep macros in my main workbook. but disable the
macros in the other workbooks. i cannot rely on users clicking disable
macros.
D
T
Tom Ogilvy
If you want to suppress a Workbook.Open Event
Application.EnableEvents = False
workbooks.Open "C:\MyFolder\Mybook.xls"
Application.EnableEvents = True
This doesn't disable events in the workbook, but it does stop the open event
from running. Leave events disabled if you want to suppress other events.
Application.EnableEvents = False
workbooks.Open "C:\MyFolder\Mybook.xls"
Application.EnableEvents = True
This doesn't disable events in the workbook, but it does stop the open event
from running. Leave events disabled if you want to suppress other events.