Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Events
I have a workbook ("Marketing.xls") and contain a macro as below. When I
save as the file to another name, I want to disable the macro. Please help ... my macro won't work Private Sub Workbook_Open() If ThisWorkbook.Name = "Marketing.XLS" Then For Each ws In Worksheets If ws.Name Like "Costing (2)" Or ws.Name Like "T&A (2)" Or ws.Name Like "Order Confirmations (2)" Then ws.Delete End If Next ws End If End Sub --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Events won't Disable! | Excel Discussion (Misc queries) | |||
events? | Excel Discussion (Misc queries) | |||
events | Excel Programming | |||
events | Excel Programming | |||
Disable Key Events | Excel Programming |