After searching for 2 hours online, I have read virtually most of the articles and have come to the conclusion that it may be impossible to lock an Excel workbook to a certain window size.
What I am trying to do is drag the bottom right corner of a workbook window to a desired width and height, and punch in some VBA code [may require API calls] and the outcome I desire is to have that window locked to that size and prevent other users from resizing it.
If there is a solution to this, then you walk in the pathways of the righteous Excel beings.
Bookmarks