Extra Security on worksheets

[pocquet]

Hi Guys,

I have a security method that evaluates as as Boolean.

I use this to disable buttons so the user cant press them however I also want to disable the ability to move from the front page worksheet unless the Boolean evaluates as true.

I was hoping that I could just Enable or Disable the worksheets (the same way that you can deactivate command buttons etc) but this dosnt seem to be possible.

The only thing i can think of is to "very hide" them unless it evaluates as true. Is there a better way to stop the use of the whole workbook unless true?

TIA

Jon

 

[Robertvk]

You could try it with a worksheet activate code.

If the Boolean = true then return to the default sheet. This solution might give you issues at a later point in time where you do want to use the sheet. You could circumvent triggering the code with Application.EnableEvents = false.

Private Sub Worksheet_Activate()

Dim bool As Boolean

If bool = True Then ActiveWorkbook.Worksheets("Sheet1").Activate

End Sub

I would suggest informing the user as to why he/she can't use the worksheet (yet).

 

[pocquet]

Ah ok,

So this would essentially keep pinging the user back to sheet1.

Thats not a bad solution and I can disable it manually if needed while developing (which was my reservation about the very hidden)

Naturally I would add a message box.