Protect UserInterface VS Protect/Unprotect
 

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

--
Desert Piranh

-----------------------------------------------------------------------
Desert Piranha's Profile: http://www.excelforum.com/member.php...fo&userid=2893
View this thread: http://www.excelforum.com/showthread.php?threadid=50665

Protect UserInterface VS Protect/Unprotect
 

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

Protect UserInterface VS Protect/Unprotect
 

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

Tom Ogilvy Wrote:
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



--
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