View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
filo666 filo666 is offline
external usenet poster
 
Posts: 265
Default 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