Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Open Worbook and Disable Macros
I know how to open a workbook using VBA, but how do i open a workbook and
disable its macros. D |
#2
|
|||
|
|||
First, just open Excel by itself and disable macros (ToolsMacrosSecurity, etc.). Then open the workbook with the macros you don't
want to run. HTH -- RMC,CPA "DMc2005" wrote in message ... I know how to open a workbook using VBA, but how do i open a workbook and disable its macros. D |
#3
|
|||
|
|||
Start Excel in Safe Mode:
http://office.microsoft.com/en-us/as...823931033.aspx -- Gary''s Student "DMc2005" wrote: I know how to open a workbook using VBA, but how do i open a workbook and disable its macros. D |
#4
|
|||
|
|||
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 "R. Choate" wrote in message ... First, just open Excel by itself and disable macros (ToolsMacrosSecurity, etc.). Then open the workbook with the macros you don't want to run. HTH -- RMC,CPA "DMc2005" wrote in message ... I know how to open a workbook using VBA, but how do i open a workbook and disable its macros. D |
#5
|
|||
|
|||
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. -- Regards, Tom Ogilvy "DMc2005" wrote in message ... I know how to open a workbook using VBA, but how do i open a workbook and disable its macros. D |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|