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

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

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

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

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