+ Reply to Thread
Results 1 to 8 of 8

Personal.xlsb blocking userform on workbook_open

  1. #1
    Registered User
    Join Date
    12-31-2015
    Location
    Barreiro, Portugal
    MS-Off Ver
    MS Office 365
    Posts
    84

    Personal.xlsb blocking userform on workbook_open

    Hi everyone,

    I have a personal.xlsb file that opens whenever I open an excel file. It has some macros stored but nothing related to this case I will explain.

    On my "main" file, I have a workbook_open that calls a user form.

    Ever since I have the personal.xlsb, that user form does not show when I open the file like it used to do.

    The userform works if I run it from inside the VBA window.

    What do I need to change?

    Here's the code to call the userform and the userform code itself:

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Thank you.

  2. #2
    Valued Forum Contributor
    Join Date
    03-16-2017
    Location
    UK
    MS-Off Ver
    2016
    Posts
    371

    Re: Personal.xlsb blocking userform on workbook_open

    Have you tried changing the ambiguous
    Please Login or Register  to view this content.
    to the explicit
    Please Login or Register  to view this content.
    ?

    Also try changing your
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.

    Let me know if it works. Stabbing in the dark without a sample file unfortunately.
    Design everything to be as simple as possible, but no simpler.

  3. #3
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,421

    Re: Personal.xlsb blocking userform on workbook_open

    As a test, can you keep the personal.xlsb but comment out all its code? Then completely restart Excel and load your "main" file. Just to see if it has an effect.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  4. #4
    Registered User
    Join Date
    12-31-2015
    Location
    Barreiro, Portugal
    MS-Off Ver
    MS Office 365
    Posts
    84

    Re: Personal.xlsb blocking userform on workbook_open

    @AlphaFrog

    Thanks for the advice, but didn't change anything.

    @Stormin

    Funny thing. It worked the first time, but when I tried to do one the changes at the time to test which made the difference, none work, and when I made both changes again, it no longer worked.

    I will try to produce a sample file when I can (from the main file), but it's kinda hard because except for that savings sheet, there is nothing else that makes the userform show.

    (I added a button to call the userform in the meantime, at least like that it works)

    Thank you both for your replies.

  5. #5
    Registered User
    Join Date
    12-31-2015
    Location
    Barreiro, Portugal
    MS-Off Ver
    MS Office 365
    Posts
    84

    Re: Personal.xlsb blocking userform on workbook_open

    Here's the promised template
    Attached Files Attached Files

  6. #6
    Valued Forum Contributor
    Join Date
    03-16-2017
    Location
    UK
    MS-Off Ver
    2016
    Posts
    371

    Re: Personal.xlsb blocking userform on workbook_open

    Hmm, for me, after enabling macros the userform opens as expected when you open the file. Sorry I can't replicate the issue

  7. #7
    Registered User
    Join Date
    12-31-2015
    Location
    Barreiro, Portugal
    MS-Off Ver
    MS Office 365
    Posts
    84

    Re: Personal.xlsb blocking userform on workbook_open

    It's alright.

    For some reason, the first time I open excel it works fine, it's just on the after. Maybe it's a different issue.

    Thank you for your help anyway.

    I'm gonna consider it solved.

  8. #8
    Valued Forum Contributor
    Join Date
    03-16-2017
    Location
    UK
    MS-Off Ver
    2016
    Posts
    371

    Re: Personal.xlsb blocking userform on workbook_open

    If that takes care of your original question, please select Thread Tools from the menu link above to mark this thread as SOLVED.
    To say thanks to the user(s) who contributed towards the solution, you can use the "Add Reputation" button on their helpful post(s).
    Thanks!

+ 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. Activate UserForm in Personal.xlsb from Any Workbook
    By nva2k4 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-09-2016, 05:39 PM
  2. Trouble passing variable to Userform in Personal.xlsb
    By davepoth in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-12-2015, 05:26 PM
  3. [SOLVED] Personal.XLSB macro pasting into Personal.XLSB
    By davepoth in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-11-2015, 07:40 PM
  4. Running a Personal.XLSB Macro From Within Another Personal.XLSB Macro
    By js0873 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 06-23-2015, 09:58 AM
  5. Replies: 0
    Last Post: 01-15-2015, 05:53 AM
  6. Run userform in a worksheet from personal.xlsb
    By crossy5575 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-18-2012, 05:29 PM
  7. Replies: 0
    Last Post: 05-10-2012, 09:22 AM

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