+ Reply to Thread
Results 1 to 3 of 3

Excel 2003 does not remember user defined options

  1. #1
    Registered User
    Join Date
    02-24-2010
    Location
    Teesside, England
    MS-Off Ver
    Excel 2003
    Posts
    2

    Excel 2003 does not remember user defined options

    Hi,

    I hope someone could shed some light on this one! One of our users goes into tools, options and places a tick in 'Ignore other applications' under the general tab and removes the tick from 'move selection after enter' under the edit tab. The user then clicks on ok and closes down Excel.

    Upon opening Excel next time round, they have noticed that these options which they have disabled/enabled are no longer effective. If we go back into options as above, the options which were selected/de-selected have gone back to what they were previously. It would appear as though Excel is not remembering these settings which have been selected by the user.

    Even if I change these options on an existing Excel workbook, then save, close the workbook and then re-open, these options are not remembered. I have also tried to create a default Excel template, apply these options and then save the template to c:\program files\microsoft office\office11\xlstart but no difference to the issue.

    The user would like these options to be remembered so that every time they open Excel, they do not have to re-apply the settings. I have tested this issue within Excel 2003 on numerous machines within our Network and the same problem happens.

    Any ideas, any help would be greatly appreciated

    Thanks

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Excel 2003 does not remember user defined options

    Hello mr_smurf,

    Welcome to the Forum!

    You can change these settings whenever the workbook opens by using the follolwing code.
    Please Login or Register  to view this content.
    How to Save a Workbook Event Macro
    1. Copy the macro using CTRL+C keys.
    2. Open your Workbook and Right Click on any Worksheet's Name Tab
    3. Left Click on View Code in the pop up menu.
    4. Press ALT+F11 keys to open the Visual Basic Editor.
    5. Press CTRL+R keys to shift the focus to the Project Explorer Window
    6. Press the Down Arrow Key until ThisWorkbook is highlighted in blue.
    7. Press the Enter key to move the cursor to the Code Window
    8. Paste the macro code using CTRL+V
    9. Save the macro in your Workbook using CTRL+S
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Registered User
    Join Date
    02-24-2010
    Location
    Teesside, England
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Excel 2003 does not remember user defined options

    Thanks for that.

    I have tried it and it appears that the macro code only works for the workbook which you are adding it to. So therefore if the user tries to start a new workbook or work on existing one which the macro code was not applied to, the settings are not carried over.

    Any idea if there is any way we can apply the settings so that they are applied to any workbook, whether it is a new one or an existing one without having to enter the above macro code for every workbook?

    Thanks

    James

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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