Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
My code is still not working -- Excel 2000 Worksheet protection
Hi;
I just about have a project for a shared workbook with a friend. I use Excel 2002; he uses Excel 2000. I have got everything to mix and match except for work sheet protection. My code follows: Public ThisExcelVersion As Variant Sub ExecProtect() ' ' ExecProtect Macro ' If ThisExcelVersion = 10 Then MembList.Protect _ Password:="bill", _ DrawingObjects:=True, _ Contents:=True, _ Scenarios:=True, _ UserInterfaceOnly:=True, _ AllowFormattingCells:=True, _ AllowFormattingColumns:=False, _ AllowFormattingRows:=True, _ AllowInsertingColumns:=True, _ AllowInsertingRows:=True, _ AllowInsertingHyperlinks:=True, _ AllowDeletingColumns:=True, _ AllowDeletingRows:=True, _ AllowSorting:=True, _ AllowFiltering:=True, _ AllowUsingPivotTables:=True Else MembList.Protect _ Password:="bill", _ DrawingObjects:=True, _ Contents:=True, _ Scenarios:=True, _ UserInterfaceOnly:=True End If End Sub In particular, I can not find any reassurance in my manuals, online, or googleing that for the version 9 (i.e < version 10) that 'Password' is used correctly. Any help welcomed. This little piece of code is breaking me and a personal project that I am generally proud of and ready to share. Regards Bill |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using AutoFilter with worksheet protection in 2000 vs. 2003 | Excel Discussion (Misc queries) | |||
worksheet protection excel 2000 vrs 2003 | Excel Programming | |||
Excel 2000 AutoFilter and Worksheet protection | Excel Programming | |||
Excel 2000 VBA Code not working in Excel 2002 | Excel Programming | |||
Excel 2000 code not working in XP | Excel Programming |