Reply to thread

Message: [QUOTE="CER, post: 3259463"] I recorded a macro (don't know enough to write one yet) to hide certain columns, then password protect the sheet, but allow filtering, sorting, pivot tables and formatting columns and rows. However, it doesn't check those options when I run it. Any help is appreciated. Here's the code: Columns("A:D").Select Selection.EntireColumn.Hidden = True ActiveWindow.SmallScroll ToRight:=5 Columns("S:S").Select Selection.EntireColumn.Hidden = True ActiveWindow.LargeScroll ToRight:=-2 ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True _ , AllowFormattingColumns:=True, AllowFormattingRows:=True, AllowSorting:= _True, AllowFiltering:=True, AllowUsingPivotTables:=True ActiveSheet.EnableSelection = xlNoRestrictions ActiveSheet.Protect Password:="aaaa" [/QUOTE]