Prev: Excel 2007 Not Drawing Correctly
Next: Working of formula in Macro.
From: Robert Crandal on 9 Feb 2010 03:00
Is there any way to disable the "Protect Workbook"
button in Excel 2007?? Just curious if there any ways
to prevent this option.

The reason I'm asking about this is because my workbook
contains lots of VBA code in which I set a sheet's "visible"
property to "xlVeryHidden" or "xlVisible". So, if someone
protects the workbook, the VBA code in the workbook
will crash if it encounters a line of code that attempts to
change any sheet's "visible" property.

thank u


From: Per Jessen on 9 Feb 2010 03:55
As far as I know you can not prevent protection, but you can test if the
workbook has been protected. It the workbook is protected, prompt user to
unprotect then run the macro again.

See below how to test:

Sub aaa()
If ThisWorkbook.ProtectStructure = True Then
msg = MsgBox("Protected")
Else
msg = MsgBox("Unprotected")
End If
End Sub

Regards,
Per

"Robert Crandal" <nobody(a)gmail.com> skrev i meddelelsen
news:KC8cn.75460$JE2.51882(a)newsfe09.iad...
> Is there any way to disable the "Protect Workbook"
> button in Excel 2007?? Just curious if there any ways
> to prevent this option.
>
> The reason I'm asking about this is because my workbook
> contains lots of VBA code in which I set a sheet's "visible"
> property to "xlVeryHidden" or "xlVisible". So, if someone
> protects the workbook, the VBA code in the workbook
> will crash if it encounters a line of code that attempts to
> change any sheet's "visible" property.
>
> thank u
>
>
From: Paul on 9 Feb 2010 06:18
Why not protect the workbook yourself, as part of your code, then you have
direct control over what the user can do.

The trade off is that you'll have to unprotect the workbook each time you
want to make your visibility changes, but this should make the whole process
much more robust.
--
If the post is helpful, please consider donating something to an animal
charity on my behalf.


"Robert Crandal" wrote:

> Is there any way to disable the "Protect Workbook"
> button in Excel 2007?? Just curious if there any ways
> to prevent this option.
>
> The reason I'm asking about this is because my workbook
> contains lots of VBA code in which I set a sheet's "visible"
> property to "xlVeryHidden" or "xlVisible". So, if someone
> protects the workbook, the VBA code in the workbook
> will crash if it encounters a line of code that attempts to
> change any sheet's "visible" property.
>
> thank u
>
>
> .
>
 | 
Pages: 1
Prev: Excel 2007 Not Drawing Correctly
Next: Working of formula in Macro.