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
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
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
, dguillett1 dguille...@gmail.com 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 Yellow
On Sheet2 I have some