Protect UserInterface VS Protect/Unprotect

[Desert Piranha]

Hi all,

Senero 1 - On workbook open use 'UserInterfaceOnly:=True'

Senero 2 - In each macro use 'Unprotect' at start, and 'Protect' a
ending.

Pro's and Con's of using each senero?
Why use one senero over the other?
Instances where one senero should be used over the other?
Thoughts on both ways

 

[Tom Ogilvy]

Using UserInterfaceOnly:=True does not unprotect the workbook

in xl2002,xl2003, you have to supply the password in your code - but that
would be true for either method.

UserInterfaceOnly:=True still has some limitations on what you can do as I
recall, although I can't think of anything off hand.

--
Regards,
Tom Ogilvy




"Desert Piranha"

 

[Desert Piranha]

Hi Tom,

Thx for your input. So it appears that it would be a better practice to
use
unprotect/protect in code, rather than the UserInterfaceOnly.

Dave

Using UserInterfaceOnly:=True does not unprotect the workbook

in xl2002,xl2003, you have to supply the password in your code - but
that
would be true for either method.

UserInterfaceOnly:=True still has some limitations on what you can do
as I
recall, although I can't think of anything off hand.

--
Regards,
Tom Ogilvy




"Desert Piranha"
message