+ Reply to Thread
Results 1 to 2 of 2

Advanced Option adjustments - need for one spreadsheet only, not all excel files.

  1. #1
    Registered User
    Join Date
    09-07-2011
    Location
    usa
    MS-Off Ver
    Excel 2007
    Posts
    2

    Advanced Option adjustments - need for one spreadsheet only, not all excel files.

    I have a spreadsheet that I need multiple users from different desktops to be able to use on a server network. I have formatted a spreadsheet to allow the cursor to move to the right instead of down using the below function:

    Click the MS Office Button in the Upper Left
    Click the Excel Options button at the bottom of the MS Office Workpane
    Go down the list to ADVANCED, click on it
    Under Editing Options the VERY FIRST choice, make sure the After pressing Enter, move selection box is CHECKED.
    In the Direction Box immediately below, use the drop down list box and choose:RIGHT

    This works great, until you open a new spreadsheet, and it wants to use the same logic. Or in my case, every person would have to install the options on thier computer and then turn back when they are done. I want to only have it use this method on this particular spreadsheet - any thoughts on how to do?

    thanks!

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Advanced Option adjustments - need for one spreadsheet only, not all excel files.

    A bit of VBA would do it:

    Please Login or Register  to view this content.
    Place in the ThisWorkbook module.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

+ 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. Replies: 0
    Last Post: 10-30-2012, 06:40 AM
  2. Formula to replace advanced filter option for unique values
    By scaffdog845 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-11-2009, 06:53 PM
  3. [SOLVED] MP3 files and Excel spreadsheet
    By [email protected] in forum Excel General
    Replies: 6
    Last Post: 07-17-2006, 05:55 PM
  4. Replies: 3
    Last Post: 11-05-2005, 12:10 PM
  5. Top N - Advanced Option Sub-totals.
    By David Z. in forum Excel General
    Replies: 0
    Last Post: 03-01-2005, 08:18 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