+ Reply to Thread
Results 1 to 2 of 2

on userform: cancel button and save button have close workbook so cannot access code

  1. #1
    Registered User
    Join Date
    12-21-2015
    Location
    chongqing,china
    MS-Off Ver
    2013
    Posts
    7

    on userform: cancel button and save button have close workbook so cannot access code

    Have a user form with Clear, Cancel, Okay and save buttons. the clear, clears the form, the cancel closes the book, the okay, edits the sheet and makes the save button visible, the save button saves the sheet in pdf format and closes the program. I can't access the code because of the userform. Is there any way to circumvent this loop? I have no previous versions or autosaves.
    Bryan

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2506 Win 11
    Posts
    24,772

    Re: on userform: cancel button and save button have close workbook so cannot access code

    Can you see the user form in design view when you press Alt + F11?
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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] UserForm with Cancel Button to stop Loop Code
    By gsandy in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-06-2015, 03:07 PM
  2. vba code to disable only close button and close through a button in Excel workbook
    By atif_ar in forum Excel Programming / VBA / Macros
    Replies: 47
    Last Post: 11-23-2014, 02:41 PM
  3. Help for Code for Cancel Button on Userform.
    By allens12 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 03-16-2014, 11:32 PM
  4. VBA Code to Disable Excel Close button also disabling my Close Button
    By akynyemi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-28-2013, 12:56 PM
  5. Code for save and close Button on Userform
    By cjames2012 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-16-2013, 12:49 AM
  6. VBA User Form - Linking Close Button and Cancel Button
    By nivassrii in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-26-2011, 07:05 AM
  7. button to save and close the workbook
    By Darrell456 in forum Excel General
    Replies: 3
    Last Post: 12-14-2009, 03:54 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