| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Bypass a function in a Macro
I am building a Macro that can run on a worksheet training matrix whether if
is filtered or not. It works beautifully as long as the file is filtered but need to work both ways. Here is the text I have for my macro so far Sheets("Tech Plan").Select ActiveSheet.Unprotect ("MPT8883900") ActiveSheet.ShowAllData ActiveSheet.Range("$A$10:$BO$569").AutoFilter Field:=53 ActiveSheet.Range("$A$10:$BO$569").AutoFilter Field:=53, Criteria1:="X" ActiveSheet.Protect ("MPT8883900") I am trying to bypass the ShowAllData line if it has already been unfiltered. I have about 60 files to run this on and would appreciate any help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Bypass Auto-Open Procedure | Excel Discussion (Misc queries) | |||
| Bypass Auto_open Macro in Excel 2007 | Excel Discussion (Misc queries) | |||
| Import Text File Window Bypass | Excel Discussion (Misc queries) | |||
| Bypass prompt to open XML file as XML list? | Excel Discussion (Misc queries) | |||
| any way to bypass Excel Limit of 255 rows? | Charts and Charting in Excel | |||
Threaded Mode
