Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hide a worksheet
Hello,
I have a macro that works great. It works on check box and deletes the sheet I do not need. However, I have one worksheet that I do not want to delete, I would like to hide it. An example is: Private Sub CheckBox3_Click() Application.DisplayAlerts = False Sheets("Checklist").Delete Sheets("Agenda").Delete Sheets("Comparison").Delete The sheet I want to hide is: Sheets("Information").Visible = False Could you tell me what I am doing wrong? Any help is appreciated. Thank you -- thank you mac |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to hide a worksheet | Excel Discussion (Misc queries) | |||
d worksheet bar is being hide | Excel Worksheet Functions | |||
how to hide worksheet using VB | Excel Worksheet Functions | |||
hide worksheet | Excel Discussion (Misc queries) | |||
How do I hide a worksheet in Excel and use a password to un-hide . | Excel Discussion (Misc queries) |