Copy/paste this into the ThisWorkbook module. Now, on ANY sheet if you
select cell f12 you will goto m95. I suspect you may prefer to have this in
a right click or double click event instead.
Private Sub Workbook_SheetSelectionChange _
(ByVal Sh As Object, ByVal Target As Range)
If Target.Address = "$F$12" Then Range("m95").Select
End Sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Tim" wrote in message
...
Hi there,
I have 100 worksheets with different names.
At cell f10 of each worksheet... I want to go to cell m95 on each
worksheet.
If I use hyperlink, I have to create each one seperately on each
worksheet.
Is there anyway I can create one for all worksheets?
thanks