use the sheet's deactivate event
to reactivate it ?

Private Sub Worksheet_Deactivate()
Me.Activate
End Sub


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


?B?Sy5BLiBIdWVzdG9u?= <K.A.
wrote:

I know how to remove the sheet tabs at Tools, Options, then uncheck
Sheet tabs. But that does not disable the ability to change sheets
with Ctrl-PgUp and Ctrl-PgDn. Is there a way to disable that function
in Excel?

Thank you