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 | |||
Analysis Toolpack Issues in Excel 2007 (Office 2007 Enterprise) | Excel Discussion (Misc queries) | |||
Excel 2007 files not showing on screen when opened in Excel 2007 | Setting up and Configuration of Excel | |||
Conflict in excel 2007 with Outlook 2007 attachment excel | Excel Discussion (Misc queries) | |||
Labels: Unable to import all records Excel 2007 to Word 2007 Mailm | Excel Discussion (Misc queries) | |||
Excel 2007 Macro Help (Excel 2003 not working in 2007) | Excel Discussion (Misc queries) |