RE: Applying business logic in navigating between Worksheets

[Dhimit]

RE: Applying business logic in navigating between Worksheets

Hi,

Is it possible to prevent user 'toggling' to another worksheet unless it meets a condition in the current worksheet ?!

i.e 'Lock' the current worksheet until an action is completed.

Dhimit

 

[ammdumas]

I beleive what you want is to add code to the following subroutine in MyWorkbook...

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
if 'your code looking at the required condition not met Then
'some witty message
End
else
'go ahead and switch sheets
End Sub

 

[Dhimit]

Re:

Thanks for your prompt response.

Do you mind giving me the EXACT syntax since my business logic is quite simple :

IF (Worksheet Cell Value < 0) OR
(Worksheet Cell Value > 0)
THEN don't switch sheets
ELSE switch sheets
END IF

Do you also mind directing me where to place this code from the menu options ?!

Dhimit