View Single Post
  #3   Report Post  
Bob Phillips
 
Posts: n/a
Default

Maybe you want book events for this


'This is workbook event code.
'To input this code, right click on the Excel icon on the worksheet
'(or next to the File menu if you maximise your workbooks),
'select View Code from the menu, and paste the code

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
MsgBox Sh.Name & " activated"
End Sub

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Paul B" wrote in message
...
M.Siler, you could you the worksheet activate event like this, put in

sheet
code

Private Sub Worksheet_Activate()
MsgBox "You just clicked on this sheet"
End Sub
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"M.Siler" wrote in message
...
How can I make a note or window popup each time a sheet is accessed? I
thought I could use the Input Message on Data Validation, but you have

to
be in a specific cell.