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.
Thanks,
Marc.
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.
