Disable VBA code execution when loading a workbook

C

Charles

How do I control the execution of the VBA Code in a spread sheet when I first
load the workbook.
I would like a dialog box to ask if I want to execute the code or not whenI
open the workbook?
Can any one suggest a way to do that???
 
E

Earl Kiosterud

Charles,

You could use a flag. In module ThisWorkbook:

Private Sub Workbook_Open()
If MsgBox("Do you want to run the macros?", vbYesNo, "Hey") = vbYes Then
MacRun = True
End Sub

Now in your macros you can test this switch to determine whether to do stuff
or not

In a general module

Public MacRun as Boolean ' This line must be before any subs,
' (and only in one module).

Sub whatever()
If not MacRun then exit sub
..
' your macro code
..
End sub
 
Top