Create a "cell button" to hide selected cells.
If your post can be interpreted literally...meaning that you want a button to
hide/unhide entire columns...
Try this:
Select columns D,E, and F
From the Excel main menu:
<data<group and outline<Group
That will display a [-] button above the worksheet.
Clicking on that button hides the columns and changes the button to [+]
Click on the [+] button to redisplay the columns.
Post back with any questions.
Does that help?
***********
Regards,
Ron
XL2002, WinXP
"Shoolin Patel" wrote:
I want to setup or enter a function in a cell that will allow me to use that
cell as a "button". I want to setup this cell so that when I click on it, it
will hide selected cells.
For example:
Clicking on cell "A1" allows me to hide columns D,E and F.
I'd appreciate any kind of help on this.
|