MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Help protected sheets & Filters

Posted by Marc van Ingen on November 08, 2001 10:31 AM

Whenever I protect my worksheets, the filters I have used don't work anymore.Is there anyway to bypass this?, maybe with a macro, but so that the rest of the sheet still remains protected.



Posted by Tom Urtis on November 08, 2001 10:47 AM

No problem just begin your macro (after you select your worksheet) with the line:

ActiveWorksheet.Unprotect ("YourPassword")
'Insert your filter code here

'And end your macro with:
ActiveWorksheet.Protect ("YourPassword")

Tom Urtis

Posted by Tom Urtis on November 08, 2001 10:51 AM

Correction !!

Sorry, those lines should read
ActiveSheet, NOT ActiveWorksheet

T. U.