Sheet Protection

  • Thread starter Thread starter Amy
  • Start date Start date
A

Amy

Hi everyone,

I have a spreadsheet and we need to be able to protect it
so that people can only edit columns C, D and L.
The only problem here is that it is a shared workbook, and
people are working in it at the same time. Also, we need
autofilter to work - that is the main problem - how do we
get it to work?

Any solutions or ideas on how to approach this would be
greatly appreciated!

Thanks!
 
Hi Amy

No experience with shared workbooks
Only know that you better avoid using them
autofilter to work
Click to expand...


Private Sub Workbook_Open()
Worksheets("Sheet1").EnableAutoFilter = True
Worksheets("Sheet1").Protect UserInterfaceOnly:=True
End Sub

Right click on the Excel icon next to File in the menubar
choose view code
paste the code
Alt-Q to go back to Excel

This runs every time the workbook opens. It protects the worksheet (Sheet1)and
allows users to use the AutoFilter dropdown lists
 
Back
Top