| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding / Unhiding Sheets
I have created macros to hide and unhide sheets when clicking on a button
example - Sheets("Premium Labor Utilization").Visible = Not Sheets("Premium Labor Utilization").Visible I am also assigning goups of sheets to a summary button example Application.ScreenUpdating = False Sheets("Premium Labor Utilization").Visible = Not Sheets("Premium Labor Utilization").Visible Sheets("FMLA Compliance").Visible = Not Sheets("FMLA Compliance").Visible Sheets("FLSA Compliance").Visible = Not Sheets("FLSA Compliance").Visible Sheets("Compliance Rpt").Visible = Not Sheets("Compliance Rpt").Visible Sheets("Tangible Savings Summary").Visible = Not Sheets("Tangible Savings Summary").Visible Sheets("Selection Sheet").Select The problem is that if I have already opened a sheet with an idividual button - it will close if I click on a summary button and it is one of the sheets that are part of the summary macro. Is there any way to add some sort of error checking around this so that if a sheet is already open it will not be closed ? -- Thanks Larry |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need code for hiding/unhiding sheets using checkboxes | Excel Worksheet Functions | |||
| unhiding and hiding rows | Excel Discussion (Misc queries) | |||
| Hiding & Unhiding graphs... | Charts and Charting in Excel | |||
| Hiding and unhiding sheets | Excel Discussion (Misc queries) | |||
| Hiding/Unhiding | Excel Worksheet Functions | |||
Threaded Mode
