select sheet

N

nman

I am trying to use a macro button to select a sheet from
a dropdown menu on a worksheet. I tried:

Sheets(Range("c4")).select

In addition, I need to place a button on the sheet that
is selected to go back to the original sheet.

Any advice?
 
G

Guest

is this what you want?

worksheets("NAME OF YOU WORKSHEET").range("C4").select

as for creating a button, got to "view" in your normal
excel window, "tool bars" and select "control toolbox."
you can create the button you want and right click on it
to set the properties.
 
N

nman

I am new to this so I am not sure if I conveyed my
request correctly. I am in a worksheet that contains a
drop-down box assigned to a column name (validation
feature) on another page. The column contains a list of
all worksheets.

Once I select the worksheet from the dropdown menu, I
would like to have the macro (by clicking the button) go
to the worksheet selected in the drop-down. Once I have
completed what I need to do in the selected worksheet, I
would like to have another macro (assigned to a button)
that takes me back to the worksheet that contains the
drop-down list. I know this is confusing but I am about
to pull my hair out!
 
P

Paul D

nman said:
I am trying to use a macro button to select a sheet from
a dropdown menu on a worksheet. I tried:

Sheets(Range("c4")).select
Click to expand...

assuming range C4 contains the name of the sheet you wish to select
Sheets([C4].Value).Activate

In addition, I need to place a button on the sheet that
is selected to go back to the original sheet.

Any advice?
Click to expand...

Sheets("name of original sheet").Activate

Paul D
 
Top