View Single Post
  #4   Report Post  
Anne Troy
 
Posts: n/a
Default Cell Reference Issue

Hi, Craig. You must be searching (an option in the search) AND viewing (an
option in Windows) hidden/system files.
************
Anne Troy
VBA Project Manager
www.OfficeArticles.com

"CraigM" wrote in message
...
Where can i find this file. I have searched my machine and i cannot find
it.
Regards

Craig

"Anne Troy" wrote:

The user doesn't have rights to his *.xlb file.
************
Anne Troy
www.OfficeArticles.com

"CraigM" wrote in message
...
One of our users opens excel up and for some reason the R1C1 Reference
Style
is ticked, which shows the numbers across the top of the sheet. The
user
can
take this off by going into.

Tools - Options - General and removing the tick.
However when the user closes excel and goes back into it, it defaults
back
to the numbers across the top.

I log in as admin and as myself and this does not happen. when i log in
as
these users it is set to the default of letters across the top.

Any help appreciated.

Thanks
Craig