Completely lock down Tab against Usage

[bradjedis]

Hi folks,

New to this forum, (xfer from Woody's)

I have a situation where I need to completly lockdown a tab from everyone except for me. The tab contains text and a clickable button. I am able to lockdown everything but the button.

Using Excel 2007, so when the protect dialog box appears, I know to NOT click any of the check boxes. However, I cannot figure out how to disallow anyone from clicking the button.

Any Ideas?

Thanks Brad

Oh yea, Hello Hans! good to find you again....

[HansV]

Hi Brad,

Welcome to Eileen's Lounge!

This behavior is by design - when a sheet is protected (and the "edit controls" check box is clear), the user can't change the properties of controls, but he/she can still use (=click) them.
So you'll have to check whether the sheet is protected in the code that is executed when the button is clicked, e.g.

Code: Select all

If ActiveSheet.ProtectContents = False Then
  ' Sheet is not protected, action allowed
  ...
  ...
Else
  ' Sheet is protected, action not allowed
  Beep
End If

[bradjedis]

Hans,
Thanks man, I will give it a go.

Brad

[bradjedis]

Worked great !

thanks,
Brad