+ Reply to Thread
Results 1 to 17 of 17

Sheet hide unhide with text/ symbol

  1. #1
    Registered User
    Join Date
    02-11-2017
    Location
    Singapore
    MS-Off Ver
    10
    Posts
    98

    Sheet hide unhide with text/ symbol

    Hi
    In my workbook, in Sheet 1 there is a dashboard and there is two button Hide and Display Sheet 2.
    This is done with macros.
    Now when I click display and entered password, sheet 2 will be visible.
    I now want to add one symbol or text, so that when Sheet 2 hide or unhide the symbol or text next to button will be changed .
    Just wondering is there any such function.

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Sheet hide unhide with text/ symbol

    Not sure I understand the need here. Is the text/symbol you wish to change in a cell next to the button? Do you want it to change to one thing then back again when the sheet is hidden or are you just adding to it each time?

    Perhaps if you could attach a desensitized version of your workbook and showed us what you need it would be easier to help.

    BSB

  3. #3
    Registered User
    Join Date
    02-11-2017
    Location
    Singapore
    MS-Off Ver
    10
    Posts
    98

    Re: Sheet hide unhide with text/ symbol

    Quote Originally Posted by BadlySpelledBuoy View Post
    Not sure I understand the need here. Is the text/symbol you wish to change in a cell next to the button? Do you want it to change to one thing then back again when the sheet is hidden or are you just adding to it each time?

    Perhaps if you could attach a desensitized version of your workbook and showed us what you need it would be easier to help.

    BSB
    Yes, want it to change to one thing then back again when the sheet is hidden.

  4. #4
    Registered User
    Join Date
    02-11-2017
    Location
    Singapore
    MS-Off Ver
    10
    Posts
    98

    Re: Sheet hide unhide with text/ symbol

    Quote Originally Posted by ash2017 View Post
    Yes, want it to change to one thing then back again when the sheet is hidden.
    Workbook attached with both scenarios for example
    Attached Files Attached Files

  5. #5
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Sheet hide unhide with text/ symbol

    Add the lines in red to your code:
    Please Login or Register  to view this content.
    I assume in the real workbook you'll be hiding/unhiding more than just Sheet2. If that's not the case then there's little point in using Array for one sheet.

    BSB

  6. #6
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Sheet hide unhide with text/ symbol

    Created based on post#01
    see attached workbook
    Symbol in cell changes, colour of symbol and command button changes

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Click *Add Reputation to thank those who helped you. Ask if anything is not clear

  7. #7
    Registered User
    Join Date
    02-11-2017
    Location
    Singapore
    MS-Off Ver
    10
    Posts
    98

    Re: Sheet hide unhide with text/ symbol

    Quote Originally Posted by kev_ View Post
    Created based on post#01
    see attached workbook
    Symbol in cell changes, colour of symbol and command button changes

    Please Login or Register  to view this content.
    Hi Kev,
    Excellent. Its a new learning for me. I will use this in another worksheet. Many thanks for your time and help!

  8. #8
    Registered User
    Join Date
    02-11-2017
    Location
    Singapore
    MS-Off Ver
    10
    Posts
    98

    Re: Sheet hide unhide with text/ symbol

    Quote Originally Posted by BadlySpelledBuoy View Post
    Add the lines in red to your code:
    Please Login or Register  to view this content.
    I assume in the real workbook you'll be hiding/unhiding more than just Sheet2. If that's not the case then there's little point in using Array for one sheet.

    BSB
    Hi BSB,
    Many thanks for your kind help. I was looking for exactly the same.

  9. #9
    Registered User
    Join Date
    02-11-2017
    Location
    Singapore
    MS-Off Ver
    10
    Posts
    98

    Re: Sheet hide unhide with text/ symbol

    Hi BSB,
    Sorry, Seems I am not able to apply when using the same in multiple range at the same time.
    Copy to clipboard
    Please Login or Register  to view this content.
    Last edited by ash2017; 04-16-2017 at 05:19 AM.

  10. #10
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    27,999

    Re: Sheet hide unhide with text/ symbol

    Don't quote whole posts -- it's just clutter. If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding

    For normal conversational replies, try using the QUICK REPLY box below.

  11. #11
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Sheet hide unhide with text/ symbol

    Change this
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.
    BSB

  12. #12
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Sheet hide unhide with text/ symbol

    Thanks for the rep

  13. #13
    Registered User
    Join Date
    02-11-2017
    Location
    Singapore
    MS-Off Ver
    10
    Posts
    98

    Re: Sheet hide unhide with text/ symbol

    Hi BSB, Getting error. Not working
    Last edited by ash2017; 04-16-2017 at 05:34 AM.

  14. #14
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Sheet hide unhide with text/ symbol

    Which error do you get?
    Could you post the workbook?

    BSB

  15. #15
    Valued Forum Contributor
    Join Date
    06-21-2013
    Location
    Bangladesh
    MS-Off Ver
    Excel 2000, Excel XP, Excel 2002, Excel 2007, Excel 2010, Excel 2013
    Posts
    975

    Re: Sheet hide unhide with text/ symbol

    What is the error?

  16. #16
    Registered User
    Join Date
    02-11-2017
    Location
    Singapore
    MS-Off Ver
    10
    Posts
    98

    Re: Sheet hide unhide with text/ symbol

    Hi All,
    Sorry for late reply. I found the solution. I have protected the sheet, hence the function didnt work. Now I did some changes in protection. Many thanks

  17. #17
    Registered User
    Join Date
    02-11-2017
    Location
    Singapore
    MS-Off Ver
    10
    Posts
    98

    Re: Sheet hide unhide with text/ symbol

    Deleted. Replied twice

+ 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 or Unhide Rows on one sheet based on value entered in cell on another sheet
    By wfsteadman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-20-2016, 07:30 PM
  2. Hide and unhide Sheet according to a1 value
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-11-2014, 09:03 AM
  3. [SOLVED] Hide/Unhide sheets based on text result of IF Formula in cell in another sheet
    By yukinosei in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-16-2014, 01:17 PM
  4. [SOLVED] Hide and unhide row and columns to change text in text boxes
    By Rocky2013 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-03-2013, 01:30 PM
  5. Hide and Unhide sheet
    By svirgo in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-23-2012, 08:11 PM
  6. Hide and Unhide text
    By Jumper1 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-25-2011, 12:20 PM
  7. unhide sheet, copy data, hide sheet - screenupdate = false
    By titus.hanke in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-08-2008, 02:46 PM

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