Getting Excel 2000 Options to be remembered

  • Thread starter Thread starter Mervyn Thomas
  • Start date Start date
M

Mervyn Thomas

Two questions really:
1. How do I get options for a particular workbook to be saved? I am findng
that the option to have R1C1 Reference style to be ticked does not get saved
with the workbook but other options do.
2. How can I get options to be either global for all workbooks or for a
range of workbooks?

Thanks
Mervyn
 
Mervyn


Unfortunately, R1C1 style is one of those options that is set by the first
workbook that is opened in a session. Calculation Mode is another.

You could set the R1C1 style in your Personal.xls which will open hidden with
each session of Excel, thus ensuring that the style is set.

Gord Dibben Excel MVP
 
Thanks - Another undocumented feature?
Mervyn
Gord Dibben said:
Mervyn


Unfortunately, R1C1 style is one of those options that is set by the first
workbook that is opened in a session. Calculation Mode is another.

You could set the R1C1 style in your Personal.xls which will open hidden with
each session of Excel, thus ensuring that the style is set.

Gord Dibben Excel MVP
Click to expand...
 
Back
Top