Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
problem with autofilter and question about menu bar buttons
Hi there, I'm taying to say to one of my macros that when a autofilter is
"on"(or enabled) turn it "of" (diabled it), but if it's "of" DOESN'T DO ANITHING. So I thought about: If Selection.AutoFilter = True Then Selection.AutoFilter End If but it seems that when the program execute the "if selection.autofilter" the autofilter is enabled no matter wath happens How could I make what I want???? 2) I made a customized tool bar, I have a button that protect a woorksheet and another button that unprotect the worksheet, so, the user need to press a button to use the sheet and press another button when he finished is work, How could I make that whenthe user press the button the sheet become unprotected and when he presses again (the same button) the sheet becomes protected??? something like the design button (and also I want to know if it's posible that when the button is on (sheet unprotected) the button appears with other image and when is of (sheet protected) appears with his original image TIA |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
problem with autofilter and question about menu bar buttons
No need to check
Activesheet.AutofilterMode = False end result will be no autofilter on the sheet. -- Regards, Tom Ogilvy "filo666" wrote in message ... Hi there, I'm taying to say to one of my macros that when a autofilter is "on"(or enabled) turn it "of" (diabled it), but if it's "of" DOESN'T DO ANITHING. So I thought about: If Selection.AutoFilter = True Then Selection.AutoFilter End If but it seems that when the program execute the "if selection.autofilter" the autofilter is enabled no matter wath happens How could I make what I want???? 2) I made a customized tool bar, I have a button that protect a woorksheet and another button that unprotect the worksheet, so, the user need to press a button to use the sheet and press another button when he finished is work, How could I make that whenthe user press the button the sheet become unprotected and when he presses again (the same button) the sheet becomes protected??? something like the design button (and also I want to know if it's posible that when the button is on (sheet unprotected) the button appears with other image and when is of (sheet protected) appears with his original image TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Center Autofilter buttons | Excel Discussion (Misc queries) | |||
Autofilter with drop down menu | Excel Worksheet Functions | |||
Any insight into cause of Autofilter buttons to stop working? | Excel Discussion (Misc queries) | |||
make autofilter buttons more discernable? | Excel Discussion (Misc queries) | |||
Regarding Menu buttons | Excel Programming |