Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
R1C1 settings auto changing
Excel Spreadsheet headers/columns A,B,C... are changing after a formula is
performed to numbers 1,2,3... This only happens on one spreadsheet not others. How do I stop it from automatically changing? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
R1C1 settings auto changing
Hi,
It happens if you open a workbook that has the R1C1 settings and I don't believe you can stop it except by forcing the change back with a macro. in the workbook open event module Application.ReferenceStyle = xlA1 Mike "essential" wrote: Excel Spreadsheet headers/columns A,B,C... are changing after a formula is performed to numbers 1,2,3... This only happens on one spreadsheet not others. How do I stop it from automatically changing? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
R1C1 settings auto changing
Compile error. Invalid outside procedure.
What might be the problem here? "Mike H" wrote: Hi, It happens if you open a workbook that has the R1C1 settings and I don't believe you can stop it except by forcing the change back with a macro. in the workbook open event module Application.ReferenceStyle = xlA1 Mike "essential" wrote: Excel Spreadsheet headers/columns A,B,C... are changing after a formula is performed to numbers 1,2,3... This only happens on one spreadsheet not others. How do I stop it from automatically changing? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
R1C1 settings auto changing
Hi,
I don't know what did you do? You should have done this:- Alt+F11 to open VB editor. Double click 'This workbook' and paste this in on the right Private Sub Workbook_Open() Application.ReferenceStyle = xlA1 End Sub Mike "essential" wrote: Compile error. Invalid outside procedure. What might be the problem here? "Mike H" wrote: Hi, It happens if you open a workbook that has the R1C1 settings and I don't believe you can stop it except by forcing the change back with a macro. in the workbook open event module Application.ReferenceStyle = xlA1 Mike "essential" wrote: Excel Spreadsheet headers/columns A,B,C... are changing after a formula is performed to numbers 1,2,3... This only happens on one spreadsheet not others. How do I stop it from automatically changing? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
R1C1 settings auto changing
This Macro hasn't solved the issue unfortunately.
Letters are still changing automatically. Any other suggestions perhaps? "Mike H" wrote: Hi, I don't know what did you do? You should have done this:- Alt+F11 to open VB editor. Double click 'This workbook' and paste this in on the right Private Sub Workbook_Open() Application.ReferenceStyle = xlA1 End Sub Mike "essential" wrote: Compile error. Invalid outside procedure. What might be the problem here? "Mike H" wrote: Hi, It happens if you open a workbook that has the R1C1 settings and I don't believe you can stop it except by forcing the change back with a macro. in the workbook open event module Application.ReferenceStyle = xlA1 Mike "essential" wrote: Excel Spreadsheet headers/columns A,B,C... are changing after a formula is performed to numbers 1,2,3... This only happens on one spreadsheet not others. How do I stop it from automatically changing? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
R1C1 settings auto changing
Originally I hadn't added the macro correctly. Since trying this Macro it has
not been successful. Are there any other suggestions? "essential" wrote: This Macro hasn't solved the issue unfortunately. Letters are still changing automatically. Any other suggestions perhaps? "Mike H" wrote: Hi, I don't know what did you do? You should have done this:- Alt+F11 to open VB editor. Double click 'This workbook' and paste this in on the right Private Sub Workbook_Open() Application.ReferenceStyle = xlA1 End Sub Mike "essential" wrote: Compile error. Invalid outside procedure. What might be the problem here? "Mike H" wrote: Hi, It happens if you open a workbook that has the R1C1 settings and I don't believe you can stop it except by forcing the change back with a macro. in the workbook open event module Application.ReferenceStyle = xlA1 Mike "essential" wrote: Excel Spreadsheet headers/columns A,B,C... are changing after a formula is performed to numbers 1,2,3... This only happens on one spreadsheet not others. How do I stop it from automatically changing? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Settings Keep Changing to Manual Calculation | Excel Discussion (Misc queries) | |||
Changing print settings permanently | Excel Discussion (Misc queries) | |||
Changing the default settings on the comment box | Excel Discussion (Misc queries) | |||
Opening Excel after changing settings and add-ins | Excel Discussion (Misc queries) | |||
Macro for changing print settings | Excel Discussion (Misc queries) |