+ Reply to Thread
Results 1 to 4 of 4

Use a Shape as a Toggle Button to Show and Hide a Worksheet

  1. #1
    Forum Contributor
    Join Date
    06-21-2010
    Location
    -
    MS-Off Ver
    Excel 2010
    Posts
    1,211

    Use a Shape as a Toggle Button to Show and Hide a Worksheet

    I'm trying to use a Shape (Rounded Rectangle 3) as a toggle button to show and hide a worksheet called Comments and at the same time change the text in the shape so it reads 'Show Comments' when the Comments worksheet is hidden and 'Hide Comments' when the Comments worksheet is visible.

    This is what I have so far but it isn't working, what am I doing wrong?

    Please Login or Register  to view this content.
    Many thanks
    Thanks,
    HangMan

    You can say "Thank you!" by clicking Add Reputation below the post.
    Please, mark your thread [SOLVED] if you are happy with the solution.

  2. #2
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Use a Shape as a Toggle Button to Show and Hide a Worksheet

    maybe so
    Please Login or Register  to view this content.

  3. #3
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Use a Shape as a Toggle Button to Show and Hide a Worksheet

    Hi HangMan
    Try this code
    Please Login or Register  to view this content.
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  4. #4
    Forum Contributor
    Join Date
    06-21-2010
    Location
    -
    MS-Off Ver
    Excel 2010
    Posts
    1,211

    Re: Use a Shape as a Toggle Button to Show and Hide a Worksheet

    Hi Nilem and Yasser,

    Many thanks, both work perfectly... I edited the post as I just figured out to add the remaining functionality...

    Many thanks to you obth for your help
    Last edited by HangMan; 11-19-2015 at 10:05 AM.

+ 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. Show/Hide Rows & Columns Toggle Button
    By axegrynder in forum Excel General
    Replies: 2
    Last Post: 06-29-2015, 06:38 PM
  2. [SOLVED] Hide Show Excel Toolbars using a Toggle Button
    By HangMan in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 07-11-2012, 05:11 PM
  3. [SOLVED] Make a Shape behave like a Toggle Button
    By HangMan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-09-2012, 11:43 AM
  4. VBA hide row based on pull down with button to toggle show/hide
    By myronr in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-12-2012, 06:07 PM
  5. [SOLVED] Toggle text Show/Hide Macro
    By theghost in forum Excel General
    Replies: 2
    Last Post: 04-12-2012, 02:41 PM
  6. Toggle Hide/ Show Named Ranges
    By jordan2322 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-11-2012, 06:33 PM
  7. [SOLVED] Can value at A1 toggle hide/show of row 2?
    By kj in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-16-2005, 12:29 AM

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