Results 1 to 15 of 15

Cannot remove the effects of deleted Auto_Close()

Threaded View

  1. #1
    Registered User
    Join Date
    04-17-2024
    Location
    San Diego, CA
    MS-Off Ver
    Office Pro Plus 2016
    Posts
    5

    Cannot remove the effects of deleted Auto_Close()

    Fitness contains 1 sheet to monitor weight loss. The first 5 columns remain stationery indicating planned period by period target weights. The next 2 columns show the targets adjusted as desired to be realistic and compared to the originals. Actual weight is manually entered periodically in the 8th column with results automatically appearing in the following 4 columns conditionally formatted green, black, or red depending on if positive, unchanged, or negative. The current day target and actual figures conditionally turn orange.

    The workbook is VBA'ized only to run automatically upon opening and calls a sub that causes a couple of cells to continuously blink alternating colors as well as to manually close the workbook without saving changes if desired without a close prompt appearing.

    It all works perfectly...unless an unrelated Workbook2 is open at the same time in which case Fitness immediately reopens once closed. It can never be closed permanently, whether saved or not, unless Workbook2 has first been closed.

    So I conceded to live with a close prompt and deleted the Auto_Close sub. However, my baffling problem is that now even with no Auto_Close, the computer restarted, and a close prompt appearing, Fitness continues to always immediately restart once closed, whether saved or not, if Workbook2 is open. Only after Workbook2 is closed can I close Fitness.

    I had no problem before I first added Auto_Close so that seems to have caused the problem. Why does the problem continue even though Auto_Close is gone?

    Workbook_Open is in ThisWorkbook of Fitness and calls the StartBlink sub which is in Module1. Module2 contains (which I later removed) the Auto_Close() sub which actuates ThisWorkbook.Saved = True.

    Thanks for you help!

    (I'm new here. If Fitness.xlsm is not attached, please let me know and I'll try again)
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro VBA - Remove empty rows and columns with total deleted in msg
    By SmurofNeves in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-25-2015, 06:17 AM
  2. [SOLVED] Remove Conditional Formats but not the Effects
    By mokht in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-05-2015, 10:46 AM
  3. [SOLVED] How to remove a deleted named range completely
    By megaiooo in forum Excel General
    Replies: 8
    Last Post: 08-16-2013, 09:01 PM
  4. Button to Remove duplicate and pasting the deleted row in another sheet
    By lovinguy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-15-2013, 12:24 AM
  5. Auto_Close
    By JohnUK in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-26-2006, 10:25 AM
  6. Remove Entire subtotal row will be deleted
    By NoelH in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-21-2006, 08:00 PM
  7. [SOLVED] Auto_Close() not running
    By Steve Barnett in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-09-2005, 05:05 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