+ Reply to Thread
Results 1 to 2 of 2

Hiding and Unhiding worksheets

  1. #1
    Forum Contributor
    Join Date
    11-30-2020
    Location
    Ny
    MS-Off Ver
    Office 365
    Posts
    173

    Hiding and Unhiding worksheets

    I have a workbook with 20 sheets I created a macro to pull up a hidden sheet with instructions, from any sheet in the workbook. That works fine but when exiting the instruction sheet excel automatically goes to the last sheet in the workbook and not the sheet the macro was called from. Here is the code I'm using, what am i doing wrong? Thankx!

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Last edited by jeffreybrown; 12-15-2021 at 07:54 PM. Reason: Please use code tags!

  2. #2
    Forum Expert WideBoyDixon's Avatar
    Join Date
    10-03-2016
    Location
    Sheffield, UK
    MS-Off Ver
    365
    Posts
    2,182

    Re: Hiding and Unhiding worksheets

    I think you'll need to "remember" which sheet was active when you show the instructions and restore it later:

    Please Login or Register  to view this content.
    Note: untested.

    WBD
    Office 365 on Windows 11, looking for rep!

+ 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. [SOLVED] Hiding and Unhiding Specific Excel worksheets
    By Renleff in forum Excel General
    Replies: 5
    Last Post: 10-04-2013, 07:32 PM
  2. [SOLVED] Hiding & Unhiding Worksheets
    By andrewc in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-04-2013, 03:58 AM
  3. Hiding unhiding worksheets in a workbook
    By mwedi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-08-2012, 09:36 AM
  4. Excel 2007 Hiding/Unhiding Worksheets Using Code
    By mab in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-04-2010, 11:44 AM
  5. Hiding / Unhiding Columns on Multiple Worksheets
    By TomTom_BV in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-25-2009, 04:55 AM
  6. Hiding and Unhiding two sets of worksheets
    By Glio in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-14-2008, 03:09 PM
  7. [SOLVED] Hiding and Unhiding Worksheets
    By Rob in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-25-2006, 07:15 AM
  8. Hiding/UnHiding Selected Worksheets
    By Craig in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-27-2005, 06:45 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