R1C1 Referency Style Policy
 

Is there a way to prevent the R1C1 reference policy from being used in excel
by using a group policy?

If not, how can I prevent it from being the default setting?

Thanks,
Jasper

R1C1 Referency Style Policy
 

Hi,

I'm not sure about group policy but you could use the workbook open event to
change it

Private Sub Workbook_Open()
With Application
.ReferenceStyle = xlA1
End With
End Sub

Mike

"Jasper Recto" wrote:

Is there a way to prevent the R1C1 reference policy from being used in excel
by using a group policy?

If not, how can I prevent it from being the default setting?

Thanks,
Jasper

R1C1 Referency Style Policy
 

Hi,

to the best of my knowledge R1C1 style is not the default, A1 style is.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Jasper Recto" wrote:

Is there a way to prevent the R1C1 reference policy from being used in excel
by using a group policy?

If not, how can I prevent it from being the default setting?

Thanks,
Jasper

R1C1 Referency Style Policy
 

This setting is picked up from the first workbook that you open in that
session. I don't think you can change the default behavior.

You could use an application event (selection change???) that changes the
reference style to what you like--but what about the people who like this
setting.

I know I very rarely use it, but I do like it when I'm checking formulas in a
column for consistency -- or writing a macro and I want to check my .formulaR1C1
string.

Jasper Recto wrote:

Is there a way to prevent the R1C1 reference policy from being used in excel
by using a group policy?

If not, how can I prevent it from being the default setting?

Thanks,
Jasper

--

Dave Peterson