| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Hide a worksheet
Do you mean the below line doesnt work...It should..
Sheets("Information").Visible = False There are 3 states for the visible property. Try one of these.. Sheets("Information").Visible = xlSheetHidden Sheets("Information").Visible = xlSheetVeryHidden Sheets("Information").Visible = xlSheetVisible If this post helps click Yes --------------- Jacob Skaria "mac" wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Hide a worksheet
Hi Mac,
The following macro works for me Private Sub CheckBox3_Click() Application.DisplayAlerts = False Sheets("Checklist").Delete Sheets("Agenda").Delete Sheets("Comparison").Delete Sheets("Information").Visible = False End Sub -- If this post helps click Yes --------------- Peggy Shepard "mac" wrote: 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 |
| Reply |
| 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) | |||
Linear Mode
