+ Reply to Thread
Results 1 to 2 of 2

Saving spreadsheet when clicking on a cell or button

  1. #1
    Registered User
    Join Date
    03-23-2018
    Location
    Montreal, Canada
    MS-Off Ver
    10
    Posts
    14

    Saving spreadsheet when clicking on a cell or button

    I would like to be able to do the following:

    Create a Macro or VBA code to:

    - open the Windows dialogue box when I click on a cell or a button and "Save", or "Save As" the Excel file and return to my spreadsheet

    - "Exit without saving" or "Save and Exit"

    Can you help me? Thanks..

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Saving spreadsheet when clicking on a cell or button

    We're always keen to help, but w,hat might be more useful for you if you really want to understand more about VBA would be to use the macro recorder to capture some code.

    Then copy the code here so that we can advise you how to then edit and simply it to make it more efficient.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ 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. VBA To copy 4 cells into the same excel spreadsheet by clicking button
    By chris1888 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-18-2020, 01:35 PM
  2. Delete cell values upon clicking on submit button
    By markusvirus in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-16-2015, 10:56 AM
  3. [SOLVED] How to activate a cell on clicking a radio button in Excel?
    By Scofield24 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-13-2013, 04:36 PM
  4. Exiting a cell when clicking on a command button
    By jcl20 in forum Excel General
    Replies: 1
    Last Post: 07-06-2008, 10:32 AM
  5. [SOLVED] help with automating saving spreadsheet on the click of a button
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-22-2006, 09:15 AM
  6. saving the spreed sheet by clicking on a cell?
    By DORI in forum Excel General
    Replies: 4
    Last Post: 11-22-2005, 06:10 AM
  7. Choosing different cell values by user clicking a button
    By alymcmorland in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-04-2005, 11:41 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