Locked shapes moving in shared Excel file

[drefiek2]

Hi, I have a shared Excel spreadsheet with many shapes in. The spreadsheet is locked with a password and all shapes have the following format settings:

Lock aspect ratio CHECKED
Don't move or size with cells CHECKED
Locked CHECKED

However when different users use the spreadsheet, after time, shapes start resizing and moving around on their own.

Can anyone explain why this happens? It is madly frustrating and I cannot figure out why it is doing this despite all shapes having the above settings.

 

[duggie33]

My only thought is that the sheet is not "Protected" at all times. I have sheets that are normally protected, but are unprotected during execution of a macro. Sometimes macros can adjust formatting of columns, rows, shapes, etc.

Doug

 

[drefiek2]

I think it is printer related - I have a SaveAsPDF macro button which will utilise each computer's printing ability. I tried changing the printer around to different ones and I can see shapes move more for some and less for others when I press the button, in fact one printer doesn't move the shapes at all. Very bizarre, so hopefully there is a fix or a workaround for this somewhere. I am not sure whether vba can force choose a printer, however.