Hi, I have searched now for a Macro to change the sheetformat in an open drawing. Alla macros that I found was made to update the sheet format in many files in a folder. I just want to with a single click change the sheet format to a specified format in a specified folder.

I also want it to update the sheetformat in all sheets in a drawing and not to change the scale.

Any idéas?