View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
michael michael is offline
external usenet poster
 
Posts: 11
Default 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