View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sheldon Sheldon is offline
external usenet poster
 
Posts: 51
Default 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