Hi is there a way to run a macro event when someone maximizes or restores the application window. The reason I ask is when the user restores the application window from maximized i want the contents in the workbook to stay zoomed to the size of the window and vise versa. I have a workbook with a userworksheet and should always show columns a to k no matter the size of the window.