Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding a button when hiding rows
Hi Guys, Can someone help me out with the following. I've put a button on a sheet and when I hide the row that the button sits in, the button stays visible. Is it possible to associate the button with a cell and when the row is hidden the button is also hidden. Thanks, Richard. -- fergusor ------------------------------------------------------------------------ fergusor's Profile: http://www.excelforum.com/member.php...fo&userid=6201 View this thread: http://www.excelforum.com/showthread...hreadid=569986 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding a button when hiding rows
Hi, To hide the groupling you can press Crtl + 8. Or if you want a a macro then try this code to toggle outline. Sub Grouping() ActiveWindow.DisplayOutline = Not ActiveWindow.DisplayOutline End Sub Link shows you how to add the button http://www.mrexcel.com/tip068.shtml VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=569986 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding a button when hiding rows
Thanks for the tip to hide the grouping buttons, but I haven't explained myself very well. On the actual spreadsheet, in cell A64 I have a button that inserts a number of rows. When I press the '-' button to hide the grouping the button in the cell doesn't hide with, instead just moves up and appears in a different cell. Thanks for your help. Richard. -- fergusor ------------------------------------------------------------------------ fergusor's Profile: http://www.excelforum.com/member.php...fo&userid=6201 View this thread: http://www.excelforum.com/showthread...hreadid=569986 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hide or unhide rows with button | Excel Discussion (Misc queries) | |||
Automatically Hiding Blank Rows | Excel Discussion (Misc queries) | |||
hiding rows | New Users to Excel | |||
Hiding rows before printing | Excel Discussion (Misc queries) | |||
Hiding rows based on date | Excel Worksheet Functions |