+ Reply to Thread
Results 1 to 3 of 3

Hiding a button when hiding rows

  1. #1
    Registered User
    Join Date
    02-16-2004
    Posts
    10

    Hiding a button when hiding rows

    Hi Guys,

    Can someone help me out with the following.

    I've put a button on a sheet with subtotals (+ & - in the left hand column) and when I hide a group row using the '-' button, the button in the cell that's been hidden 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.
    Last edited by fergusor; 08-09-2006 at 12:25 PM.

  2. #2
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    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

  3. #3
    Registered User
    Join Date
    02-16-2004
    Posts
    10
    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1