Macro to move between sheets
 

Hi,

I would like to have a macro that would look at a value in cell A5 and
then go to the Worksheet that has the same name.

For example if i typed Sheet 1 in cell A1 then clicked on the macro i
would automatically be taken to Sheet 1.

Is this possible?

Regards

Pete


---
Message posted from http://www.ExcelForum.com/

Macro to move between sheets
 

How about a fully automatic way. NO clicking necessary
Right click sheet tabview codeinsert this.
Now when you type sheet1 in cell a1 you will goto sheet1

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.address < "$A$1" Then Exit Sub
Sheets(Target.Value).Select
End Sub

--
Don Guillett
SalesAid Software

"Pete JM " wrote in message
...
Hi,

I would like to have a macro that would look at a value in cell A5 and
then go to the Worksheet that has the same name.

For example if i typed Sheet 1 in cell A1 then clicked on the macro i
would automatically be taken to Sheet 1.

Is this possible?

Regards

Pete


---
Message posted from http://www.ExcelForum.com/

Macro to move between sheets
 

Thank you very much for your reply its very useful.

thanks again

Pet

--
Message posted from http://www.ExcelForum.com

Macro to move between sheets
 

glad to help

--
Don Guillett
SalesAid Software

"Pete JM " wrote in message
...
Thank you very much for your reply its very useful.

thanks again

Pete


---
Message posted from http://www.ExcelForum.com/