View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Go to cell address

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