Sheet Protection

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!
 
R

Ron de Bruin

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
 
Top