+ Reply to Thread
Results 1 to 4 of 4

Macro button to HIDE rows

  1. #1
    Forum Contributor
    Join Date
    06-08-2012
    Location
    Panama City, FL
    MS-Off Ver
    Excel 2016
    Posts
    175

    Macro button to HIDE rows

    Hi All,

    I have a worksheet that I use to enter data and calculate percentages. Titles on Row 1. Data on Rows 2 and 4, %Results on Rows 3 and 5.
    On a separate tab I have a chart that displays these results.

    I would like a toggle button (or two buttons -- HIDE/UNHIDE) to display the DataRows (Rows 2 & 4) only when I am entering data. This will save me from having to select each Row to Hide them. <of course it's much larger than the sample rows I listed here>

    Any chance someone can show me how to create a Macro Button to perform this task?

    Thanks a million!

  2. #2
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Macro button to HIDE rows

    this is a very basic shell of what I think you want...the buttons are just objects that have macros assigned to them. You can adjust the macro for your dataset....HTH
    Attached Files Attached Files
    Ernest

    Please consider adding a * if I helped

    Nothing drives me crazy - I'm always close enough to walk....

  3. #3
    Forum Contributor
    Join Date
    06-08-2012
    Location
    Panama City, FL
    MS-Off Ver
    Excel 2016
    Posts
    175

    Re: Macro button to HIDE rows

    Thanks -- that did the job! I rated this FIVE STARS and Added to the Reputation -- I hope I did it correctly and that they show up.
    Have a great day!

  4. #4
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Macro button to HIDE rows

    you did it correctly and they showed up....glad I could help, thanks for the points and have a great day....

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Hide blank rows button macro
    By cabinetguy in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-30-2016, 07:21 AM
  2. Macro command button to hide empty rows
    By djauncey in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-31-2012, 10:42 AM
  3. Button to hide and unhide rows
    By twofootgiant in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-13-2008, 04:37 AM
  4. Hide Command Button & Rows
    By LaForgeOZ in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-01-2008, 08:08 PM
  5. [SOLVED] URGENT!! Use macro button to hide empty columns and rows...HELP!!!!
    By Hawk in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-08-2005, 06:05 PM

Tags for this Thread

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