View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default Options saved with the worksheet?

Different options have different scopes. But all of the Edit options are
user-level. That means they are saved in the registry when the user closes
Excel and restored when it is restarted. Ergo, none of the Edit options are
saved with the workbook.

--
Jim
"Eric" wrote in message
...
| Under tools/options, are the options saved with the worksheet, or do they
| apply across-the-board for all files that the user is working on? If I
set
| an option and send the file to someone else, who may have different
options
| set, which option settings are used when the recipient opens the file?
|
| I'm particularly interested in the options on the Edit tab, but I'd like
to
| know how this works in general.
|
| (In MS Word, some options stay with the file while others stay with the
| user. It can be very confusing!)
|
| Thanks.