Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet Navigation Help
Thank you very much! It's looking good.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tab navigation in a protected worksheet | Excel Discussion (Misc queries) | |||
Creating navigation buttons on a worksheet | New Users to Excel | |||
Worksheet Navigation | Excel Programming | |||
Worksheet Navigation | Excel Programming | |||
Worksheet Navigation | Excel Discussion (Misc queries) |