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

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

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

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