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.

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.
>

Assuming sheet 2 is hidden, the something like:

Private Sub CommandButton1_Click()
Sheets("Sheet2").Visible = True
Sheets("Sheet2").Activate
End Sub



"moez77" <(E-Mail Removed)> wrote in message
news:97E33CF9-EA50-46E7-B28C-(E-Mail Removed)...
>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.
>

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" <(E-Mail Removed)> wrote in message
news:97E33CF9-EA50-46E7-B28C-(E-Mail Removed)...
>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.
>