I am having some frustration in getting this code to work.
I have a workbook with multiple worksheets.
The workbook has the following code.
....and each worksheet has this code
....when the workbook opens its perfect, no ribbon etc, and if you navigate to any of the other worksheets the ribbon stays away. The problem I have is when the workbook is minimized (ie not full screen) for the first time ALL the ribbons/toolbars etc become visible. Once the workbook is made back to fullscreen and I navigate to any of the worksheets the ribbon/toolbars etc disappear and they stay that way even if the workbook is minimized.
So my problem is how to I make the first instance of minimizing of the workbook NOT make everything (ribbon, toolbars etc) visible. I assume I am missing something?
I would be more than happy to take away the user option of minimizing the workbook (and for that matter of closing the workbook at all) but have no idea how to do that so any help at all would be very much appreciated.
Thanks everyone.
t
Bookmarks