Is it possible to set window size on open and keep it that size

[barman]

Hi,

I have a workbook and use the following code to open it with the window set at certain size. This part works great, however the workbook is used on different size screens and if the maximize button is clicked it looks bad on large screens. Minimizing is ok because it returns to the set size... so is there a way to disable the maximize button, not allow maximizing, or keep the window the set size no matter what.

Please Login or Register  to view this content.

[Leith Ross]

Hello barman,

This macro will remove the maximize button on the Excel application window. Add a new VBA Module to your workbook and paste the code below into.

Run the macro "RemoveMaximize".

Please Login or Register  to view this content.