| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run code conditional on sheet visibility
Hi
I have a situation whereby if sheet "LogGraph3" is the only sheet visible then I do not require the Workbook_BeforeClose to run, how do I incorporate that into the following. ******Sub Starts****** Sub Workbook_BeforeClose(Cancel As Boolean) If Sheets("LogGraph3") 'is the only visible sheet' Then GoTo EarlyEnd Else Do closing code End If EarlyEnd: Some Code End Sub ******Sub Ends******* Thanks Sandy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional visibility of check box | Excel Discussion (Misc queries) | |||
| help with code for conditional summary sheet | Excel Discussion (Misc queries) | |||
| Ensure macros enabled - C. Pearson's sheet visibility method | Excel Programming | |||
| Toggle sheet visibility | Excel Programming | |||
| Excel 2002? Where to store code for all spreadsheet visibility? | Excel Programming | |||
Threaded Mode
