How to keep zoom set to 100% in a workbook?

This will have to be done at the sheet level. This is one of the rare occasions that you have to activate something in VB. Put this code in the workbook module

Please Login or Register  to view this content.

This happens when the workbook opens.

If the user changes the zoom level, this will not catch it. You could put code on each sheet module to set its zoom when it is opened or closed or even get more agressive.

Please Login or Register  to view this content.

This code will reset the Zoom Level every time a user selects any cell. The user can still change the zoom level, but it will be reset each time a new cell is selected. I don't know of any event or setting that will prevent the user from accessing the zoom level.

To the best my knowledge there is no such event. The limited amount of research I did came up with solutions similar to the ones I presented. You can't stop it, but you can reset it.

If you have it set up to reset each time a new cell is selected then there is little value resetting periodically. If a user doesn't select a cell, then why is there a need for change? No work was done. If the user does select a cell then the zoom is reset.

Besides, running timers takes overhead.

Since you can't stop the user from zooming, you need to address the issue of the images getting misaligned. Either keep them from getting misaligned at any setting or at least revert to their proper positions at 100%.