Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Allowing formatting in lower versions of EXCEL
ActiveSheet.Protect Password:="password", _
DrawingObjects:=True, Contents:=True, Scenarios:=True, _ UserInterfaceOnly:=False of course formatting and sorting won't be allowed. -- Regards, Tom Ogilvy "Stacy Haskins" wrote in message ... How can I make the following code work on verisons of Excel lower than 2002?: ActiveSheet.Protect Password:="password", DrawingObjects:=True, Contents:=True, Scenarios:=True, UserInterfaceOnly:=False, AllowFormattingCells:=True, AllowFormattingColumns:=True, AllowFormattingRows:=True, AllowInsertingColumns:=False, AllowInsertingRows:=False, AllowInsertingHyperlinks:=False, AllowDeletingColumns:=False, AllowDeletingRows:=False, AllowSorting:=True, AllowFiltering:=False, AllowUsingPivotTables:=False |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formatting - highlight Capital letters but not lower c | Excel Discussion (Misc queries) | |||
Conditional Formatting Published to Former Versions | Excel Discussion (Misc queries) | |||
Conditional Formatting - allowing for Blank Cells | Excel Discussion (Misc queries) | |||
protecting a sheet yet allowing for sorting, filtering, formatting | Excel Discussion (Misc queries) | |||
Protecting Sheet and still allowing for sorting, filtering and formatting | Excel Discussion (Misc queries) |