Excel 2000 Protect ... But Free Filter
 

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


---
Message posted from http://www.ExcelForum.com/

Excel 2000 Protect ... But Free Filter
 

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.

--
Regards,
Tom Ogilvy

"sal21 " wrote in message
...
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.....


---
Message posted from http://www.ExcelForum.com/