Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I set a macro to unhide a worksheet and stay on it?
I am trying to create a form on Excel (2007) that will contain individual
form control buttons for every worksheet in the workbook. My goal is to just display one sheet with a control button with all the options for the actual worksheets. Once the user selects the button for the worksheet he would like to see that worksheet should unhide and display. I got the macro recorded to do so but it then switches back to the form sheet. I would like for it to remain on the newly displayed worksheet. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I set a macro to unhide a worksheet and stay on it?
Show us what you have and we can modify. (it's not much, I'm sure)
"moez77" wrote: I am trying to create a form on Excel (2007) that will contain individual form control buttons for every worksheet in the workbook. My goal is to just display one sheet with a control button with all the options for the actual worksheets. Once the user selects the button for the worksheet he would like to see that worksheet should unhide and display. I got the macro recorded to do so but it then switches back to the form sheet. I would like for it to remain on the newly displayed worksheet. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I set a macro to unhide a worksheet and stay on it?
Assuming sheet 2 is hidden, the something like:
Private Sub CommandButton1_Click() Sheets("Sheet2").Visible = True Sheets("Sheet2").Activate End Sub "moez77" wrote in message ... I am trying to create a form on Excel (2007) that will contain individual form control buttons for every worksheet in the workbook. My goal is to just display one sheet with a control button with all the options for the actual worksheets. Once the user selects the button for the worksheet he would like to see that worksheet should unhide and display. I got the macro recorded to do so but it then switches back to the form sheet. I would like for it to remain on the newly displayed worksheet. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I set a macro to unhide a worksheet and stay on it?
If the button is on a UserForm, modify the code to:
Private Sub CommandButton1_Click() Sheets("Sheet2").Visible = True Sheets("Sheet2").Activate Unload Me End Sub This will close the UserForm and leave the Active sheet on screen. "moez77" wrote in message ... I am trying to create a form on Excel (2007) that will contain individual form control buttons for every worksheet in the workbook. My goal is to just display one sheet with a control button with all the options for the actual worksheets. Once the user selects the button for the worksheet he would like to see that worksheet should unhide and display. I got the macro recorded to do so but it then switches back to the form sheet. I would like for it to remain on the newly displayed worksheet. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unhide macro worksheet | Excel Discussion (Misc queries) | |||
Copy a worksheet and ensure range names stay local | Excel Programming | |||
how do i unhide a worksheet in excel 2003? unhide tab don't work | Excel Discussion (Misc queries) | |||
columns and rows on my worksheet will not stay resized | Excel Worksheet Functions | |||
combobox on worksheet won't stay in one place | Excel Programming |