popup note when a sheet is accessed

  • Thread starter Thread starter M.Siler
  • Start date Start date
M

M.Siler

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.
 
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
 
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)
 
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.
Click to expand...

I see you already got your answer, but I figured I had an obligation
to respond with the following:

This will probably rank about a "kill someone" on a scale of annoying
to crazy-making, especially if other people will have to access to the
document.

Just my two cents..

MP-
 
I hear you... This is only a quarterly update document to my boss and I want
to make sure when a this one sheet is accessed this message isn't missed. I
was hoping for something that didn't require a user action, something more
like the input validation box when you enter a specific cell.

Hey as I was typing this... Perhaps I can use a input validation message if
I can always force the active cell for a sheet when that sheet is first
selected?
 
M. Siler, you could do that this way,

Private Sub Worksheet_Activate()
Range("C2").Select
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 said:
I hear you... This is only a quarterly update document to my boss and I want
to make sure when a this one sheet is accessed this message isn't missed. I
was hoping for something that didn't require a user action, something more
like the input validation box when you enter a specific cell.

Hey as I was typing this... Perhaps I can use a input validation message if
I can always force the active cell for a sheet when that sheet is first
selected?
Click to expand...
 
Back
Top