LinkBack URL
About LinkBacks
Hi
Thanks in advance, i need help in a macro where
1. When excel opens , the format changes to R1C1 automatically.
2. when that very excel is closed, its gets back changed to A1 fromat.
Please help.
Hi
Thanks in advance, i need help in a macro where
1. When excel opens , the format changes to R1C1 automatically.
2. when that very excel is closed, its gets back changed to A1 fromat.
Please help.
Add this code in Thisworkbook Code window of the desired workbook
The reference style is application property so the change will affect all open excel workbooks.
Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
its not working...
the code has to be in the ThisWorkbook module not a normal module
Josie
if at first you don't succeed try doing it the way your wife told you to
thanks Joseph and Sixthsense
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks