Worksheet Navigation Help
 

I am using the code below in a module to allow users to easily navigate
between sheets...

Sub NavigateSheet()
Sheets("Sheet2").Select
End Sub

However, I'd like to block the navigation and show a message box if a
cell on another sheet is populated.

Any ideas?

Thank you in advance.

-M

Worksheet Navigation Help
 

Something like this perhaps:
Sub NavigateSheet()
If Sheets("OtherSht").Range("F2")<"" Then 'not blank
MsgBox "Your message"
Exit Sub
End If
Sheets("Sheet2").Select
End Sub
"michael" wrote in message
ups.com...
I am using the code below in a module to allow users to easily navigate
between sheets...

Sub NavigateSheet()
Sheets("Sheet2").Select
End Sub

However, I'd like to block the navigation and show a message box if a
cell on another sheet is populated.

Any ideas?

Thank you in advance.

-M

Worksheet Navigation Help
 

Thank you very much! It's looking good.