VBA Code to resize sheets works fine except for inserted controls

[PFDave]

Please Login or Register  to view this content.

Hi,

I'm using the above code for users to be able to resize all sheets in a workbook to a set %. The sheet tabs are hidden in this document and they navigate with buttons which is why they can't select all sheets and resize in the usual way. Regardless of that, when a page that contains an inserted control (list boxes and calendar control) the resize distorts, although sometimes looks ok. However when a selection is made the size distorts again.

Any advice on this?

[PFDave]

Please Login or Register  to view this content.

This line has been added before End Sub, but although that has seemed to work for one part, I'm still getting issues.