Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I have a workbook with worksheets created by an external ETL application. The end user needs to address data issues in some of the worksheets created. The workbook can get very wide, with many worksheets. I'd like to create macros to: * Hide_Empty_Worksheets An empty worksheet would only have a header row, i.e. row 1 contains Var1, Var2,...,VarN. No other data from row 2 and below. * Show_All_Worksheets Undo the action from above. I'd like to bind these macros to hotkeys, i.e. Cntl-Shift-H to hide and Cntl-Shift-S to show. Does anyone have similar macros that I could use, or point me in the right direction? Unfortunately I'm not an Excel macro guru, so if you're pointing me in the right direction, any helpful URL's for online resources to help with Excel programming would be useful. Thanks, Scott |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help on Macro to hide empty rows | Excel Discussion (Misc queries) | |||
URGENT!! Use macro button to hide empty columns and rows...HELP!!!! | Excel Programming | |||
Macro to hide rows with empty cells | Excel Worksheet Functions | |||
Macro that will Pull Cells from Other Worksheets if not empty? | Excel Programming | |||
if cell empty hide row macro? | Excel Programming |