+ Reply to Thread
Results 1 to 3 of 3

How to avoid multiple "close" actions, in conjunction with "personal" workbook.

  1. #1
    Registered User
    Join Date
    01-12-2015
    Location
    California, USA
    MS-Off Ver
    Excel 2007
    Posts
    3

    How to avoid multiple "close" actions, in conjunction with "personal" workbook.

    I created a "personal" workbook, and added a few simple macros and UDF's.

    Everything seems to work OK, including the UDF's.

    However now, whenever I close a workbook, it is a two step process:

    When I close the primary workbook, I then have to seperately close the personal workbook,
    even if I haven't modified any macros or UDF's and
    even if my primary workbook doesn't use any macros or UDF's.

    Is there a way to avoid the extra (manual) close?

    Thank you.

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: How to avoid multiple "close" actions, in conjunction with "personal" workbook.

    it's better saving file with udf as superstructure

  3. #3
    Registered User
    Join Date
    01-12-2015
    Location
    California, USA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: How to avoid multiple "close" actions, in conjunction with "personal" workbook.

    Thanks for the reply, but I'm not sure what that means, or how to do it.

+ 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. Replies: 4
    Last Post: 11-17-2013, 12:05 PM
  2. Replies: 2
    Last Post: 06-06-2013, 12:45 PM
  3. Create a Command Button to "Save As" and "Close" an Excel Workbook
    By thedunna in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-26-2013, 05:38 PM
  4. Call a sub statement in "Personal Macro Workbook" from "ThisWorkbo
    By QC Coug in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-26-2005, 03:05 PM
  5. [SOLVED] Macro working in "This Workbook", but not while in "Personal.xls"
    By markx in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-07-2005, 01:06 PM

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