+ Reply to Thread
Results 1 to 5 of 5

Saving a worksheet without excel remembering the last selected cell

  1. #1
    Registered User
    Join Date
    05-10-2016
    Location
    South West England
    MS-Off Ver
    Online/ 365
    Posts
    49

    Smile Saving a worksheet without excel remembering the last selected cell

    Hi there, Thanks in advance for any help provided.

    I'm sure there is a simple solution to this simple problem but google has turned up nothing as far as i'm aware.

    We are broadcasting a spreadsheet on a large tv screen in the office and are using Microsoft sharepoint and office online to enable people to edit this spreadsheet from their computers. The changes are then reflected on the screen

    Just one small problem - Before they click save, the user has to select cell A1 so that, when loaded, the spreadsheet opens and fits the screen.
    If they dont select cell A1, the main spreadsheet refreshes (reloads the saved file) and jumps to the last active cell when saved which causes the some parts of the workbook to go off screen.

    Is there a way to have excel always save pointing to a specific cell or am I going to have to keep slapping my co-workers over the head if they forget to click A1 before saving.

    Many thanks, I look forward to learning a way around this if possible

    Take Care,
    Dan

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,241

    Re: Saving a worksheet without excel remembering the last selected cell

    Put this code in the Workbook Before Close Event.
    Click on Alt + F11
    In the left window, double click on ThisWorkbook.
    Paste Code in the right window.
    Close and save the VBE and then close and save the workbook.

    Please Login or Register  to view this content.
    Alan


    Have you debugged your code?
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    05-10-2016
    Location
    South West England
    MS-Off Ver
    Online/ 365
    Posts
    49

    Cool Re: Saving a worksheet without excel remembering the last selected cell

    Hi Alan,

    Thank you for your really fast reply. I see its a basic script to tell it to select A1 prior to closing.

    Unfortunately, it hasn't worked. I've set the security settings to always run macros for now but Excel still remembers the last cell selected

    I've attached a screenshot of the VBA, hope it helps. Thanks Again

    Dan
    Attached Images Attached Images

  4. #4
    Valued Forum Contributor meabrams's Avatar
    Join Date
    10-03-2014
    Location
    USA
    MS-Off Ver
    2007, 2010, 2013, 2016
    Posts
    451

    Re: Saving a worksheet without excel remembering the last selected cell

    What file type are you savin it as: .xlsx or .xlsm
    a .xlsx file will not keep anything you enter in the vba
    a .xlsm file is a macro enabled file which should keep any macro that you and as long as you enable macros it should work.

  5. #5
    Registered User
    Join Date
    05-10-2016
    Location
    South West England
    MS-Off Ver
    Online/ 365
    Posts
    49

    Re: Saving a worksheet without excel remembering the last selected cell

    Hey,

    Thanks again. I did get a message from excel saying it needs to be saved in the different format.

    It is saved as a .xlsm and, when opened, does have VB code there. cheers

    Dan

+ 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. Saving multiple selected worksheets from a listbox as separate excel files
    By dylanrose in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-27-2015, 10:11 PM
  2. Saving a selected range of an excel sheet as PDF
    By karimretina in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-16-2014, 03:42 AM
  3. Saving selected Excel data into notepad.csv
    By trebleking in forum Excel General
    Replies: 2
    Last Post: 07-15-2014, 08:22 PM
  4. Copy Formula with Excel remembering the cell difference
    By Chris-TT in forum Excel General
    Replies: 4
    Last Post: 12-22-2010, 04:42 PM
  5. Remembering a cell location
    By DamienC in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-10-2008, 09:02 AM
  6. Remembering Cell Values
    By Don in forum Excel General
    Replies: 2
    Last Post: 07-03-2006, 11:40 AM
  7. Remembering Worksheet View after Event Code
    By clmarquez in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-19-2006, 06:10 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1