Results 1 to 3 of 3

Thread: How to run a macso when "Save" or "Save As" is choosen in Excel 2010

  1. 2013-04-26, 10:57 AM #1
    Ylva
    Ylva is offline
    Neophyte Ylva's Avatar
    Join Date
    Apr 2013
    Posts
    2
    Articles
    0

    Smile How to run a macso when "Save" or "Save As" is choosen in Excel 2010



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi!

    I want to capture the event "Save" and Save as" in Excel 2010 so that a macro runs instead with a customized dialouge box.
    I just want to know how to capture the events.

    Thankfull for any help here!
    Ylva
    Reply With Quote Reply With Quote
  2. 2013-04-26, 11:59 AM #2
    royUK
    royUK is offline
    Conjurer royUK's Avatar
    Join Date
    Mar 2011
    Location
    Derbyshire, UK
    Posts
    155
    Articles
    0
    Excel Version
    most versions
    Use the WorkBook_BeforeSave event
    Hope that helps

    Roy
    Reply With Quote Reply With Quote
  3. 2013-04-26, 12:25 PM #3
    Ylva
    Ylva is offline
    Neophyte Ylva's Avatar
    Join Date
    Apr 2013
    Posts
    2
    Articles
    0
    Quote Originally Posted by royUK View Post
    Use the WorkBook_BeforeSave event
    Thank's! It works fine!

    Ylva
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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
  •  

Forum Rules

Gravatar by 1e2.it