Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Sharing a spreadsheet with Auto FIlter, and mixed Protection
Removed Contents :=True and still get same error. This is what the event code looks like now: Private Sub Workbook_Open() With ActiveWorkbook.Sheets("Sheet1") .EnableAutoFilter = True .Protect userInterfaceOnly:=True End With End Sub ?- Levite
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Sharing a spreadsheet with Auto FIlter, and mixed Protection
I have a user that has a spreadsheet she wants people to be able to filter on and also have some (not all) the cells protected. I found a some good advice on using a Macro on the Workbook open event to accomplish this: Private Sub Workbook_Open() With...- Levite
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
