Results 1 to 3 of 3

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

  1. #1

    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

  2. #2
    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

  3. #3
    Quote Originally Posted by royUK View Post
    Use the WorkBook_BeforeSave event
    Thank's! It works fine!

    Ylva

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •