+ Reply to Thread
Results 1 to 3 of 3

Combine two Macros into one toggle button using range selections

  1. #1
    Registered User
    Join Date
    08-26-2011
    Location
    California, United States
    MS-Off Ver
    Excel 2016
    Posts
    45

    Question Combine two Macros into one toggle button using range selections

    I have two macros I recorded One macro that hides specific rows and a second that unhides the same rows. I managed to assign them each to a separate button one that hides one that unhides, but i cannot figure out how to combine both macros as a toggle onto one button. For example I want to click the button and have it show the hidden rows. Clicking the same button a second time would then hide the same rows. Below are the two macros. I could only unhide by selecting rows 5:64 I havent figured out how to unhide the specified range. tried different solutions i have found but none worked.

    Please Login or Register  to view this content.



  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Combine two Macros into one toggle button using range selections

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Registered User
    Join Date
    08-26-2011
    Location
    California, United States
    MS-Off Ver
    Excel 2016
    Posts
    45

    Re: Combine two Macros into one toggle button using range selections

    Quote Originally Posted by AlphaFrog View Post
    Please Login or Register  to view this content.
    Wow thank you so much for the quick reply. Works great.
    Last edited by Lmao; 01-28-2017 at 05:19 PM. Reason: update

+ 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. Userform Toggle or Option button based on Listbox selections
    By KML1976 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-31-2016, 10:52 AM
  2. [SOLVED] Toggle Button -Show Hide Column Range Fails
    By sl729 in forum Excel General
    Replies: 5
    Last Post: 05-22-2016, 09:17 PM
  3. Combining separate button functions into one toggle button 2011 office for mac
    By voidcreativ in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-18-2015, 09:28 AM
  4. Toggle Button Does not Toggle OFF when Clicked
    By robbfamily in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-19-2014, 05:12 PM
  5. Replies: 1
    Last Post: 02-13-2014, 10:55 PM
  6. Macro Command Button: Combine Save As CSV and Delete Unsed Rows Macros
    By mustng_sally in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-15-2013, 10:41 AM
  7. How do I toggle a button across a range of columns
    By sodaboy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-22-2005, 09: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