+ Reply to Thread
Results 1 to 4 of 4

Call userform 1 from userform 2 allowing to open workbook 1 clicking button 1

  1. #1
    Registered User
    Join Date
    03-23-2015
    Location
    Portugal
    MS-Off Ver
    Office 2013
    Posts
    2

    Call userform 1 from userform 2 allowing to open workbook 1 clicking button 1

    Good night to you all

    1- I have a userform 1 in a hided workbook 1 that has a button 1 pass protected to open it.
    2- I need a userform 2 with a button 2 to call userform 1 , that alow me to open workbook 1 by pressing button 1.

    Many thanks in advance

    FMontana

  2. #2
    Forum Contributor
    Join Date
    06-07-2014
    Posts
    192

    Re: Call userform 1 from userform 2 allowing to open workbook 1 clicking button 1

    Not sure if I understood your question fully but try the attached.

    The password is excel.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    03-23-2015
    Location
    Portugal
    MS-Off Ver
    Office 2013
    Posts
    2

    Re: Call userform 1 from userform 2 allowing to open workbook 1 clicking button 1

    Good morning chin67326

    Many thanks for your quick answer.

    Maybe I didn't explain well what I need.

    I have already made a userform 1 that was made in a workbook 1. This userform 1 is opened when open the workbook 1 thas is hided. In that userform 1 I have a password coded button that allow me to open that workbook 1. If I open this userform 1 in "stand alone" mode, it works perfectly.

    What I can't manage to do, is another userform 2 in another workbook 2 (that will be also hided, showing only the userform 2), to call the first userform 1, and when called, allow me to open workbook 1 by clicking the button in userform 1

    In attachment you can find my userform 1. Button 1 is in the right inferior corner (pass: gate37)

  4. #4
    Forum Contributor
    Join Date
    06-07-2014
    Posts
    192

    Re: Call userform 1 from userform 2 allowing to open workbook 1 clicking button 1

    Good day, I tried for quite some time to find a solution and I could not. I would leave this to a more experienced expert to answer.

+ 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] Error opening userform (clicking button)
    By adamstarr12 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-24-2014, 08:10 PM
  2. UserForm help - display list of open workbooks except workbook userform code is in
    By kensweep in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-09-2014, 12:26 PM
  3. [SOLVED] Close UserForm after clicking OK Button
    By david1987 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-09-2013, 08:15 AM
  4. Userform Command Button to open new userform
    By JamesT1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-08-2010, 12:02 PM
  5. How to open a userform just by clicking on a cell
    By ephie in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-11-2006, 09:01 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