A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Hi, michael coltart
This sounds like the VBE layout was changed or corrupted during the update. Also, the UserForm designer itself is not a dockable window, but it may currently be maximized, which explains the scroll bars and why it cannot be moved.
Here are some suggestions you can try:
In the VBE, select Window > Cascade. If the UserForm designer was maximized, this should return it to a normal window that can be moved and resized.
Select Tools > Options > Docking, make sure Properties Window is checked, then select OK. Press F4 to display Properties, drag it slowly toward the left or right edge of the VBE, and release it when the docking outline appears. Only windows listed under the Docking options can be docked.
If the layout remains stuck, close Excel, restart Windows, and run an Online Repair from Settings > Apps > Installed apps > Microsoft 365 > Modify > Online Repair.
Please note that the UserForm’s Left, Top, and size properties affect the form when it runs. They do not control the position of its design window inside the VBE.
Thank you for your patience in reading, I hope this information has been helpful to you.
If the answer is helpful, please click "Yes" and kindly upvote it. If you have extra questions about this answer, please click "Comment."
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.