Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 VBA
"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 |
#2
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 VBA
Teepee
How about the UserForm_Deactivate() event? Private Sub UserForm_Deactivate() ActiveSheet.Protect End Sub -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog: www.nickhodge.co.uk/blog/ FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007 www.officeusergroup.co.uk "teepee" wrote in message ... "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 |
#3
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 VBA
ta good idea
"Nick Hodge" wrote in message ... Teepee How about the UserForm_Deactivate() event? Private Sub UserForm_Deactivate() ActiveSheet.Protect End Sub -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog: www.nickhodge.co.uk/blog/ FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007 www.officeusergroup.co.uk "teepee" wrote in message ... "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 |
#4
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 VBA
"Nick Hodge" wrote How about the UserForm_Deactivate() event? Private Sub UserForm_Deactivate() ActiveSheet.Protect End Sub And my final dumb question - why does this subcommand not work. Presumably it goes inside the userform? |
#5
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 VBA
Correct
Thinking about it you should reference the sheet explicitly as it may ne be active Worksheets("Sheet1").Protect -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog: www.nickhodge.co.uk/blog/ FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007 www.officeusergroup.co.uk "teepee" wrote in message ... "Nick Hodge" wrote How about the UserForm_Deactivate() event? Private Sub UserForm_Deactivate() ActiveSheet.Protect End Sub And my final dumb question - why does this subcommand not work. Presumably it goes inside the userform? |
#6
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 VBA
Thanks for all your help Nick.
I've got it more or less up and running in 2007 now, albiet with some of the functionality missing - but good enough until Microsoft gets round to sorting out the compatability issues - if they ever do. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |