+ Reply to Thread
Results 1 to 4 of 4

Hid Workbook/Sheet, Now Userform Doesnt Work. Workbook Greyed Out.

  1. #1
    Registered User
    Join Date
    12-12-2016
    Location
    Tulsa, Oklahoma
    MS-Off Ver
    2016
    Posts
    5

    Hid Workbook/Sheet, Now Userform Doesnt Work. Workbook Greyed Out.

    I made a userform in VBA, got everything finished, and was looking online for a string of code to hide the worksheet and only show the userform when the excel file was opened. I found some code, used it, saved and opened the excel file. The sheet was hidden, but now my userform doesnt work. I deleted the string of code, saved my workbook again, opened it and...... it didnt change it back! Can no longer right click worksheet and select "View Object." Guessing I need to run a string to bring back my workbook/sheet? I already tried checking if ti was hidden under properties. I think the problem may have been that I hide the workbook instead of the worksheet?

    Does anyone have any suggestions? I put a lot of work into that spreadsheet and now I'm at a standstill. -_-

    Heres that the workbook/sheet look like when selected:
    http://i66.tinypic.com/98a8o7.png

    http://i68.tinypic.com/33121sj.png

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Hid Workbook/Sheet, Now Userform Doesnt Work. Workbook Greyed Out.

    Hi,

    On the View tab in the main Excel window, not the VBE, click Unhide and choose your workbook name, then save the file again.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  3. #3
    Registered User
    Join Date
    12-12-2016
    Location
    Tulsa, Oklahoma
    MS-Off Ver
    2016
    Posts
    5

    Re: Hid Workbook/Sheet, Now Userform Doesnt Work. Workbook Greyed Out.

    Jeez I'm embarrassed. That did the trick, THANK YOU!

  4. #4
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Hid Workbook/Sheet, Now Userform Doesnt Work. Workbook Greyed Out.

    You're welcome.

+ 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. Filter greyed out and does not work in specific sheet
    By GRG Stevan in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-25-2015, 02:19 AM
  2. autotab doesnt work on userform first open
    By ramzter in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-06-2014, 08:07 PM
  3. Get Data from UserForm (TextBox, ListBox) doesnt work
    By BorisMKD in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-15-2014, 05:07 AM
  4. [SOLVED] Copy Values From Each Workbook in Folder to a Single Sheet in New Workbook +Workbook names
    By Arsham24 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-21-2012, 07:42 PM
  5. Custom Sort Macro Doesnt work when workbook is shared
    By vaznlyfe in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-21-2012, 10:23 PM
  6. Formula works in dummy sheet but doesnt in the main workbook
    By amid in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-16-2009, 06:45 AM
  7. Opening an excel workbook doesnt work
    By bigdaddy3 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-10-2006, 08:15 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