I know how to open a workbook using VBA, but how do i open a workbook and
disable its macros.
D
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 (Tools>Macros>Security, etc.). Then open the workbook with the macros you don't
want to run.
HTH
--
RMC,CPA
"DMc2005" <[email protected]> wrote in message news:%[email protected]...
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" <[email protected]> wrote in message
news:%230J%[email protected]...
> 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
>
>
> "DMc2005" <[email protected]> wrote in message
> news:%[email protected]...
> 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" <[email protected]> wrote in message
news:%[email protected]...
> I know how to open a workbook using VBA, but how do i open a workbook and
> disable its macros.
>
> D
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks