Resizes Excel window to certain small size and location (hard-coded) and hide ribbon and all toolbars.
Use Resize_Me2 to save current Excel window location and sizes into settings then change location and size to certain parameters.
Use Resize_Me3 to restore to original location and size (Reading settings)
Used in one of my daily workbooks to import images from Internet (Moclif v5.8)
Ribbon hide and show macro uses ExecuteExcel4Macro as a workaround.
Worked in Excel 365 in Windows 10 as of today
Access to code is limited.
Login here using your Linkedin account. to see or download code.
No registration, not another password to remember, login using your Linkedin account and have access to all public codes in BoldCodes.com
Login
Views 579
Downloads 202
VBA-Excel
Layout+Design
ANmarAmdeen
929
Attachments
Revisions
v1.0
Friday
December
11
2020
Tags
Excel, window, resize, restore, move, , location, size, width, left, top, height, application, WindowState, ScreenUpdating, Resize_Me
