| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to Un Hide filtered rows
I have this Macro
Sub Macro2() Const csPWORD As String = "123" ActiveWorkbook.Worksheets("broker").Unprotect Password:=csPWORD ActiveSheet.ShowAllData ActiveWorkbook.Worksheets("broker").Protect Password:=csPWORD End Sub I get a bug error if the sheet is already un filtered and the next step of protecting the sheet again doesn't happen. How do I change this to search first to see if the worksheet is filtered and if it is then proceed with the rest of the Macro. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to Un Hide filtered rows | Excel Programming | |||
| Macro code to hide rows and not calculate hidden rows | Excel Discussion (Misc queries) | |||
| Delete all filtered rows from a macro? | Excel Programming | |||
| Macro for counting the number of filtered rows | Excel Programming | |||
| Filtered Visible Rows & VBA Non-Filtered Rows Displayed | Excel Programming | |||
Threaded Mode
