Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ShowAllData in all workbooks and sheets
Hi
Code required to run ShowAllData on every sheet in every open workbook, leaving filter buttons/arrows in place. Something like: With all Workbooks and all Sheets If .FilterMode Then .ShowAllData End If End With TIA -- Thank you Regards Aussie Bob C. Using Windows XP Home + Office 2003 Pro |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ShowAllData in all workbooks and sheets
Sub test()
Dim wb As Workbook Dim sh As Worksheet On Error Resume Next For Each wb In Application.Workbooks For Each sh In wb.Worksheets sh.ShowAllData Next Next On Error GoTo 0 End Sub RBS "Robert Christie" wrote in message ... Hi Code required to run ShowAllData on every sheet in every open workbook, leaving filter buttons/arrows in place. Something like: With all Workbooks and all Sheets If .FilterMode Then .ShowAllData End If End With TIA -- Thank you Regards Aussie Bob C. Using Windows XP Home + Office 2003 Pro |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
ShowAllData in all workbooks and sheets
Thanks RB
very much appreciated Aussie Bob C. "RB Smissaert" wrote: Sub test() Dim wb As Workbook Dim sh As Worksheet On Error Resume Next For Each wb In Application.Workbooks For Each sh In wb.Worksheets sh.ShowAllData Next Next On Error GoTo 0 End Sub RBS "Robert Christie" wrote in message ... Hi Code required to run ShowAllData on every sheet in every open workbook, leaving filter buttons/arrows in place. Something like: With all Workbooks and all Sheets If .FilterMode Then .ShowAllData End If End With TIA -- Thank you Regards Aussie Bob C. Using Windows XP Home + Office 2003 Pro |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sheets in a workbooks | Excel Discussion (Misc queries) | |||
ShowAllData | Excel Discussion (Misc queries) | |||
ActiveSheet.ShowAllData shows everything - way to have hidden _not_ show up? | Excel Programming | |||
Naming Workbooks and Sheets | Excel Programming | |||
vba-showalldata | Excel Programming |