Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 . |
#3
|
|||
|
|||
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 . . |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing switches focus off proper sheet | Excel Worksheet Functions | |||
Sheet protection in mass?! | New Users to Excel | |||
Cell Colors and Sheet Protection | Excel Discussion (Misc queries) | |||
Naming & renaming a sheet tab | Excel Worksheet Functions | |||
Why can't my macro use Auto Filter when I told the Sheet Protecti. | Excel Worksheet Functions |