+ Reply to Thread
Results 1 to 3 of 3

Macro to Hide and Unhide Rows but still be able to insert rows

  1. #1
    Registered User
    Join Date
    03-01-2011
    Location
    Beijing, China
    MS-Off Ver
    Excel 2010
    Posts
    2

    Question Macro to Hide and Unhide Rows but still be able to insert rows

    Hello there,

    I'm quite new to all these macro functions, but I'm putting together a Q&A sheet for the sales team and it was getting quite messy so I'm building a new one which will hide information and when the user wants they can expand or unhide the rows with the data in it.

    I did play with it a little and recorded a macro which can hide and unhide the selected section, but in the end if I insert rows above the section or inbetween topics everything slips.

    How do I make a macro that will always stick with the certain section and not slip if i add rows above or within that section.

    I have attached the file to show what I'm trying to do, but I'm a bit lost, hope someone can help me out. I'm a super new at macros so hope someone can help me.
    Attached Files Attached Files
    Last edited by majasmi; 03-01-2011 at 09:25 PM.

  2. #2
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Macro to Hide and Unhide Rows but still be able to insert rows

    hi majasmi, why not to try use standard Excel functionality, check example.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    03-01-2011
    Location
    Beijing, China
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Macro to Hide and Unhide Rows but still be able to insert rows

    hmm i didnt know about that function. that is the simplest way to do it i guess and not needing to mess around with macros. thanks!

+ 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