Cells losing alignment when plugging laptop into projector

[billfinn]

Good Morning!
I am scratching my head over this one. Every time I plug my laptop into the company projector it fouls up the alignment of the cells in the first column. I set them as left justified, save, then plug in the projector and bring the file up. All the cells in the first column have changed to be right justified. I have saved this thing about 6 times and gotten the same results.
Any thoughts about this one? I would really appreciate any ideas. This one makes me look like an idiot when I go to show the boss something and parts of it are unreadable.
thanks,
Bill

 

[mole999]

the cells change or the display ?

could you push it across 1 column ?

I can understand the screen and projector resolutions being different

 

[billfinn]

mole999,
As far as I can tell the cells change. I unplug from the projector and bring the laptop back to my desk and all of the cells in that column are right justified. I have done nothing except display the sheet using the projector.
Thanks much,
Bill

 

[mole999]

any macros in the file ?

does it happen on any file ?

 

[Greg Truby]

does it happen on any file ?

Indeed - I would see if this replicates with another workbook.

If not, then are you sure you're using the same file? After resetting the cells' alignment to left yet again, I would change the interior shading of a cell to yellow or something unique. And then see if, when I'm all done, do I end up with right-aligned cells that also have my yellow shading? If not, then I'm accidentally using two different versions of the file somehow.

 

[billfinn]

Mole999,
I will try it with another file. I am 99.999% sure it has always been the same file. It's the only one I have used the projector for. Also, the file does have macros.
Thanks again,
Bill

 

[mole999]

text defaults to left aligned and right for numbers, if something is clearing the default format, then it will default so I'm sure you have numbers in the errant column. If you have just ordinary numbers but want them as text, place an apostrophe in front to force it

 

[billfinn]

Mole999,
Agreed. The problem only bothers with cells containing text. Numbers are fine on the right. My issue is that the text gets aligned on the right and some of it becomes unreadable. Waiting for access to conference room to try another file.
Thanks again
Bill.

 

[mole999]

what do you have as
Workbook_Open()
and
Worksheet_Activate()

for macros, might be something in there