+ Reply to Thread
Results 1 to 2 of 2

Message Box after Save

  1. #1
    Registered User
    Join Date
    11-03-2013
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    22

    Message Box after Save

    Hello,

    I have a code which prompts a message box asking the user if they want to save a worksheet to a new workbook, the user can select Yes or No.

    I would like that if the user selects Yes after the save a message box appears with my specified text.

    Only a beginner in VBA and coding so any help is appreciated.

    thank you

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Message Box after Save

    hi

    open visual basic

    find your work book using project explorer

    right click on the this workbook icon and select view code.

    select workbook and then before save in the two list boxes that appear

    then type

    Please Login or Register  to view this content.
    Attached Files Attached Files

+ 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. How to Turn Off the Save Changes Message?
    By oskar270 in forum Excel General
    Replies: 8
    Last Post: 10-01-2011, 09:34 PM
  2. Save Sent Message To....
    By JBeaucaire in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-03-2011, 10:35 PM
  3. Error message trying to save
    By soma104 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-14-2010, 10:21 AM
  4. Message Box before Save
    By kajero in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-11-2006, 11:25 AM
  5. Message box before save
    By Chance224 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-15-2005, 02: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