Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook Deactivate
I am using the following code in ThisWorkbook:
Private Sub Workbook_Deactivate() MsgBox "Deactivating Workbook" End Sub This works fine in most cases. However, if I have selected an imbedde chart on a worksheet, I find the macro doesn't run. Can anyone help -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook Deactivate
You could try selecting an other portion of the sheet
eg sheets(1).select range("a1").select this will ensure that no graph is selected and you can close th workbook as per the rest of your code -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Shared Workbook" seems to deactivate features like macros | Excel Discussion (Misc queries) | |||
Deactivate web toolbar | Excel Discussion (Misc queries) | |||
Deactivate Formula | Excel Programming | |||
Workbook Deactivate Event | Excel Programming | |||
UserForms to deactivate workbook | Excel Programming |