| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Show All Data
I have some quite complex filters and am trying to make the spreadsheet more
user friendly. I have included a button to restore the Show All Data using the VBA: ActiveSheet.ShowAllData This works, but only if there has been a filter applied. If the user clicks the button again (without a filter being present) I get the following error message - "Run Time error 1004 - ShowAllData method of Worksheet class failed". How can I stop this error message, or better still advise the user (MSGBOX?) that all the data is currently being shown? Thank you for your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Tables: Don't show data for detail, but still show subtotals | Excel Worksheet Functions | |||
| Data Labels- POssible to show data value and data label together? | Charts and Charting in Excel | |||
| Pivot tables - how to show only show data or < $10k | Excel Discussion (Misc queries) | |||
| show 3 sets of data per data point in a scatter plot | Charts and Charting in Excel | |||
| how do i sort a worksheet data to show repetitve data and show | Excel Worksheet Functions | |||
Threaded Mode
