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.22hevz_1138681801.9505@excelforu m-nospam.com wrote in
message news:Desert.Piranha.22hevz_1138681801.9505@excelfo rum-nospam.com...
Hi all,
Senero 1 - On workbook open use 'UserInterfaceOnly:=True'
Senero 2 - In each macro use 'Unprotect' at start, and 'Protect' at
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?
--
Desert Piranha
------------------------------------------------------------------------
Desert Piranha's Profile:
http://www.excelforum.com/member.php...o&userid=28934
View this thread: http://www.excelforum.com/showthread...hreadid=506654