software

Is there any way to eliminate having the R1C1 property from being changed
when you open a spreadsheet. I want to keep the alpabetic references and not
allow the R1C1 propery to be modified by any open action?

Hello bill
Tools, Options, General tab and untick quot;R1C1 Referencequot;

HTH
Cordially
Pascal

quot;Bill Kquot; lt;Bill K @discussions.microsoft.comgt; a écrit dans le message de
news: ...
gt; Is there any way to eliminate having the R1C1 property from being changed
gt; when you open a spreadsheet. I want to keep the alpabetic references and
gt; not
gt; allow the R1C1 propery to be modified by any open action?
Pascal,

What I really want is to keep any spreadsheets from changing the quot;R1C1
Referencequot; setting. I can establish the Alpha characters like you suggest
but if you open a spreadsheet that was emailed to you and it has the numeric
references it changes the setting in the General tab permanently.

Is there any way to ensure that the R1C1 check box is never altered?

Thanks!

Bill

quot;papouquot; wrote:

gt; Hello bill
gt; Tools, Options, General tab and untick quot;R1C1 Referencequot;
gt;
gt; HTH
gt; Cordially
gt; Pascal
gt;
gt; quot;Bill Kquot; lt;Bill K @discussions.microsoft.comgt; a écrit dans le message de
gt; news: ...
gt; gt; Is there any way to eliminate having the R1C1 property from being changed
gt; gt; when you open a spreadsheet. I want to keep the alpabetic references and
gt; gt; not
gt; gt; allow the R1C1 propery to be modified by any open action?
gt;
gt;
gt;