2011 at 8:45 PM, dguillett1 wrote:
> Post your file with a complete explanation and tell us your excel version.
>
> -Original Message- From: Bob
> Sent: Saturday, August 20, 2011 7:46 AM
>
> To: MS EXCEL AND VBA MACROS
> Subject: $$Excel-Macros$$ Hide Rows that are NOT
Post your file with a complete explanation and tell us your excel version.
-Original Message-
From: Bob
Sent: Saturday, August 20, 2011 7:46 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Hide Rows that are NOT Yellow
On Sheet2 I have some rows that are highlighted in yellow
Hi Bob,
You can use Color Filter For this :
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Bob
Sent: Saturday, August 20, 2011 6:17 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Hide Rows that are NOT Yellow
On Sheet2
On Sheet2 I have some rows that are highlighted in yellow and some
not. I'd like for when the user clicks on the command button to hide
all the rows NOT in Yellow. And another command button to unhide. I'm
familiar with installing the command buttons, just don't know how to
write the code to hide a
