Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I turn off macros when programmatically opening a workbook.
Hi,
I'm trying to turn off a macro that runs when I open a workbook programmatically. I'm not sure how to do this. I want to do (programmatically) the equivalent of pressing the 'Disable macros' button when I open this program. I have workarounds if this doesn't work, but would like to do something quick and easy! Thanks! Phil |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I turn off macros when programmatically opening a workbook.
Phil
If you're auto macros are of the AutoOpen variety, they won't execute when you open a workbook via code. If they are events like Workbook_Open, then Application.EnableEvents = False Workbooks.Open etc.. Application.EnableEvents = True -- Dick Kusleika Excel MVP Daily Dose of Excel www.dicks-blog.com PhilBerkhof wrote: Hi, I'm trying to turn off a macro that runs when I open a workbook programmatically. I'm not sure how to do this. I want to do (programmatically) the equivalent of pressing the 'Disable macros' button when I open this program. I have workarounds if this doesn't work, but would like to do something quick and easy! Thanks! Phil |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I turn off macros when programmatically opening a workbook.
Private Sub Workbook_Open()
End Sub Above is where the macro is running from. If you do not want it to rum, remove the code. You can put it some where else to make it available to run. "PhilBerkhof" wrote: Hi, I'm trying to turn off a macro that runs when I open a workbook programmatically. I'm not sure how to do this. I want to do (programmatically) the equivalent of pressing the 'Disable macros' button when I open this program. I have workarounds if this doesn't work, but would like to do something quick and easy! Thanks! Phil |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I turn off macros when programmatically opening a workbook.
Phil,
The code I have placed below came from some kind soul posted on this UseNet. When the Workbook_Open procedure runs upon opening the file--we will call the child document--this code will look to see if the file name you supply is open--lets call it the parent document. If the parent document is open it will exit the Workbook_Open procedure. 1. Paste the line of code mentioned below in your Workbook_Open procedure located in the code for 'ThisWorkbook'; change the file name. 2. Next Paste the TestWorkbookOpen function below the end of the Workbook_Open procedure. Public Sub Workbook_Open() Application.ScreenUpdating = False '1. Place this line of code in your workbook_open procedure... If TestWorkbookOpen("TheParentFileName.xls") Then Exit Sub 'Your code here... Application.ScreenUpdating = True End Sub ' 2. Next Paste the TestWorkbookOpen function below the end of the Workbook_Open procedure. Function TestWorkbookOpen(WorkBookName As String) As Boolean ' returns TRUE if the workbook is open TestWorkbookOpen = False On Error GoTo WorkBookNotOpen If Len(Application.Workbooks(WorkBookName).Name) 0 Then TestWorkbookOpen = True Exit Function End If WorkBookNotOpen: End Function |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disable macros on a programmatically opening .xls file | Excel Discussion (Misc queries) | |||
Disable Macros when opening workbook | Excel Programming | |||
Turn Off Macros With Workbook Open | Excel Programming | |||
Open workbook-macros enabled, opening another with macros | Excel Programming | |||
Opening a workbook containing macros from VB | Excel Programming |