+ Reply to Thread
Results 1 to 4 of 4

Anyway to Unhide a workbook that malfunctioned?

  1. #1
    Forum Contributor
    Join Date
    01-08-2017
    Location
    Salt Lake City, Ut.
    MS-Off Ver
    2019 and 365
    Posts
    135

    Angry Anyway to Unhide a workbook that malfunctioned?

    I created a workbook, moved it to a new drive, that I had not set to backup. Made some modifications to the code and run it. In the export function, I hide the workbook, but apparently it malfunctioned, and if I restart it, it still shows as hidden. I can access the VB code, and have attempted to run the unhide routine there, but always get error: Runtime error 91: object variable or with variable not set. I have been unable to unhide or find any routine that will allow me to unhide the workbook to recover it.

    Any ideas is appreciated?

  2. #2
    Forum Expert JLGWhiz's Avatar
    Join Date
    02-20-2011
    Location
    Florida, USA
    MS-Off Ver
    Windows 10, Excel 2013
    Posts
    2,070

    Re: Anyway to Unhide a workbook that malfunctioned?

    Have you tried going to "View" on the ribbon and use the widow Hide/Unhide feature?
    Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
    Just when I think I am smart, I learn something new!

  3. #3
    Forum Contributor
    Join Date
    01-08-2017
    Location
    Salt Lake City, Ut.
    MS-Off Ver
    2019 and 365
    Posts
    135

    Re: Anyway to Unhide a workbook that malfunctioned?

    Thanks JLGWhiz, that worked, although I had to run some other code to show the ribbon again, and the only feature under View that was not dimmed out was the Unhide. Thanks so much.

  4. #4
    Forum Expert JLGWhiz's Avatar
    Join Date
    02-20-2011
    Location
    Florida, USA
    MS-Off Ver
    Windows 10, Excel 2013
    Posts
    2,070

    Re: Anyway to Unhide a workbook that malfunctioned?

    Quote Originally Posted by dentler View Post
    Thanks JLGWhiz, that worked, although I had to run some other code to show the ribbon again, and the only feature under View that was not dimmed out was the Unhide. Thanks so much.
    You're welcome,
    regards, JLG

+ 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] VBA to hide/unhide a workbook
    By Keibri in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-18-2018, 12:11 PM
  2. [SOLVED] How to unhide workbook
    By ImranBhatti in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-03-2016, 08:27 AM
  3. Replies: 3
    Last Post: 12-13-2013, 03:37 PM
  4. this workbook code to unhide rows
    By mardyl in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-21-2011, 02:55 PM
  5. Unhide workbook
    By Corcodel in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-13-2011, 03:07 PM
  6. Replies: 1
    Last Post: 07-11-2006, 02:50 PM
  7. Unhide a workbook?
    By Mis in forum Excel General
    Replies: 1
    Last Post: 06-30-2006, 01:45 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