View Single Post
  #4   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.windows.group_policy
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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