popup note when a sheet is accessed
 

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


"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.

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.

On Mon, 18 Jul 2005 14:30:14 -0400, "M.Siler" wrote:
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.

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-

--
"Learning is a behavior that results from consequences."
B.F. Skinner

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?

"Mangus Pyke" wrote in message
...
On Mon, 18 Jul 2005 14:30:14 -0400, "M.Siler" wrote:
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.

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-

--
"Learning is a behavior that results from consequences."
B.F. Skinner

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" wrote in message
...
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?

"Mangus Pyke" wrote in message
...
On Mon, 18 Jul 2005 14:30:14 -0400, "M.Siler" wrote:
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.

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-

--
"Learning is a behavior that results from consequences."
B.F. Skinner