Excel 2000 Protect ... But Free Filter

  • Thread starter Thread starter sal21
  • Start date Start date
S

sal21

I have make a protection on a sheet, it contain a flitre, when i push on
this filtre is not active!!!!!

My problem is activate a protection on sheet and free the filtre....
ARG.....
 
In code in the workbook open event you need to do

worksheets("Sheet1").EnableAutofilter = True
worksheets("Sheet1").Protect UserinterfaceOnly:=True

see help on the protect method for explanation of UsedInterfaceOnly setting.
 
Back
Top