ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   side-by-side worksheets revisited (https://www.excelbanter.com/excel-programming/312879-side-side-worksheets-revisited.html)

Sheldon

side-by-side worksheets revisited
 
I have two worksheets in the same workbook displayed at the same time
(Side-by-side). For discussion sake lets call the windows - windowL (the
left one) and windowR (the right one).

The active window has the small icons at the top right of the window
(minimize, maximize, and close). When windowL is active, I don't want those
icons to show. I need to force the user to use my macro connected by a shape
to close the left window. Or how do I capture the click of any of the icons
in windowL to direct the code.

Thanks


All times are GMT +1. The time now is 08:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com