Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect, unprotect | Excel Discussion (Misc queries) | |||
protect and unprotect | Excel Programming | |||
protect and unprotect | Excel Programming | |||
Unprotect and protect.... | Excel Programming | |||
Thanks Otto.......Unprotect and re-Protect | Excel Programming |