select sheet
 

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?

select sheet
 

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.
-----Original Message-----
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?
.

select sheet
 

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!
-----Original Message-----
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.
-----Original Message-----
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?
.

.

select sheet
 

"nman" wrote in message
...
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

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?

Sheets("name of original sheet").Activate

Paul D