Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Hi Experts,
Can someone help me out. I have a spreadsheet with the code Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) If Range("B1").Value = "" Then MsgBox ("s.v.p. je naam invullen!") End If End Sub in ThisWorkbook. The spreadsheet must be filled in by various colleagues. On opening the file a dialog about turning the macro's off or on, I know for sure my colleagus will push the first button and will turn off the macro. Is there a way to run the macro automatically, so without the dialog. Altering the secutiry level is nog option, so I guess some additional VBA will do the trick but I really don't know how. Can someone help me out?? It would be much appreciated. Regards, Anja |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to autoRun macro on WB open | Excel Discussion (Misc queries) | |||
Autorun Macro | Excel Discussion (Misc queries) | |||
Autorun macro | Excel Worksheet Functions | |||
MACRO AUTORUN | Excel Discussion (Misc queries) | |||
Autorun macro by date | Excel Discussion (Misc queries) |