Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
![]() "Nick Hodge" wrote I would say, from my testing yes. To be honest, I've always done that unprotect, change, protect as these were not available pre XP. Thanks Nick. I think I can workaround. I put ActiveSheet.Unprotect at the top of the userform that controls the VBA. I just need to find a way to put ActiveSheet.Protect in automatically when the userform exits. If you have any ideas.... Thanks for your advise TP |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 xlsx files open as Read-Only in Excel 2003 after Compat | Excel Discussion (Misc queries) | |||
Problems with my links to an excel 2007 file from a word 2007 file | Links and Linking in Excel | |||
Excel 2007, why is it slow opening files created in Excel 2003? | Excel Discussion (Misc queries) | |||
Office 2007 Pro Plus 2007 (Beta) - getting small red and green arr | Excel Discussion (Misc queries) | |||
Trouble opening large size Excel file 155Mb in Excel 2007 | Excel Discussion (Misc queries) |