Excel 2000 Protect ... But Free Filter

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.....
 
T

Tom Ogilvy

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.
 
Top