Filter Switches vs Sheet Protection?
Excel 2000 ... TabSheet contains "Filter" Switches ...
However, when I "Protect" TabSheet "Filter" Switches appear to deactivate ... That said ... is there a way to set TabSheet Protection so "Filter" Switches will still work??? Thanks ... Kha |
I believe with XL2000 you need to use:
With ActiveSheet .Protect Password:="hello", UserInterfaceOnly:=True .EnableAutoFilter = True End With With XL2003 you have the option of setting it when you protect the sheet, or you could use: With ActiveSheet .Protect Password:="hello", AllowFiltering:=True End With --- HTH Jason Atlanta, GA -----Original Message----- Excel 2000 ... TabSheet contains "Filter" Switches ... However, when I "Protect" TabSheet "Filter" Switches appear to deactivate ... That said ... is there a way to set TabSheet Protection so "Filter" Switches will still work??? Thanks ... Kha . |
Jason ... I put Macro into my spread sheet & gave it a
name ... & ran it ... & it worked as though TabSheet was password "Protected" with "Hello". After unprotecting ... "Filters" appeared to work fine regardless if sheet ... not protected, protected w/o password, & protected with password (this is fine). However, I would prefer this capability with "Protection" only (instead of "Password Protection") ... That said ... what little giration do I need to make to this Macro to make this happen??? ... Thanks ... Kha -----Original Message----- I believe with XL2000 you need to use: With ActiveSheet .Protect Password:="hello", UserInterfaceOnly:=True .EnableAutoFilter = True End With With XL2003 you have the option of setting it when you protect the sheet, or you could use: With ActiveSheet .Protect Password:="hello", AllowFiltering:=True End With --- HTH Jason Atlanta, GA -----Original Message----- Excel 2000 ... TabSheet contains "Filter" Switches ... However, when I "Protect" TabSheet "Filter" Switches appear to deactivate ... That said ... is there a way to set TabSheet Protection so "Filter" Switches will still work??? Thanks ... Kha . . |
You can either leave this portion out:
Password:="hello", or you can make it: Password:="", Ken wrote: Jason ... I put Macro into my spread sheet & gave it a name ... & ran it ... & it worked as though TabSheet was password "Protected" with "Hello". After unprotecting ... "Filters" appeared to work fine regardless if sheet ... not protected, protected w/o password, & protected with password (this is fine). However, I would prefer this capability with "Protection" only (instead of "Password Protection") ... That said ... what little giration do I need to make to this Macro to make this happen??? ... Thanks ... Kha -----Original Message----- I believe with XL2000 you need to use: With ActiveSheet .Protect Password:="hello", UserInterfaceOnly:=True .EnableAutoFilter = True End With With XL2003 you have the option of setting it when you protect the sheet, or you could use: With ActiveSheet .Protect Password:="hello", AllowFiltering:=True End With --- HTH Jason Atlanta, GA -----Original Message----- Excel 2000 ... TabSheet contains "Filter" Switches ... However, when I "Protect" TabSheet "Filter" Switches appear to deactivate ... That said ... is there a way to set TabSheet Protection so "Filter" Switches will still work??? Thanks ... Kha . . -- Dave Peterson |
All times are GMT +1. The time now is 10:45 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com