+ Reply to Thread
Results 1 to 4 of 4

Close workbook with out saving (Workbook_BeforeClose)

  1. #1
    Forum Contributor Rick_Stanich's Avatar
    Join Date
    11-21-2005
    Location
    Ladson SC
    MS-Off Ver
    Office365
    Posts
    1,192

    Close workbook with out saving (Workbook_BeforeClose)

    I read two pages on "Workbook_BeforeClose" trying to find a relative answer, no luck.

    I want to able to close a workbook with out saving and not rely on the user pressing the correct button, can this be done?
    Please Login or Register  to view this content.
    Thank you
    Last edited by Rick_Stanich; 10-16-2008 at 12:21 PM.
    Regards

    Rick
    Win10, Office 365

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    Why are you selecting A3 in the final part & is bLogin a Global variable?
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    This might be what you want

    Please Login or Register  to view this content.

  4. #4
    Forum Contributor Rick_Stanich's Avatar
    Join Date
    11-21-2005
    Location
    Ladson SC
    MS-Off Ver
    Office365
    Posts
    1,192
    [Embarrassed]
    OMG!
    [/Embarrassed]
    That was too easy, I need to give you a higher challenge

+ 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. Closing the workbook without saving
    By tushar@excel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-30-2008, 05:20 AM
  2. Close word without saving
    By benhiggi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-08-2008, 06:07 AM
  3. Activate workbook before close event when excel is closed
    By RobynC in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-05-2007, 06:19 AM
  4. Workbook before close event
    By solnajeff in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-16-2007, 08:51 AM
  5. Automatically Close Workbook If Another Workbook Is Opened
    By knucklemonkey in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-29-2006, 07:01 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