philfer
02-28-2008, 12:01 PM
hello,
I have a workbook that when it opens it gets all the toolbars that the user has on their screen and makes them invisible and also hides the scrollbars. Thus the page looks like a poster (as it is a snapshot of financial info for mangement).
When the before workbook close method is invoked. The toolbars that the user had on their screen are made visible as are the scrollbars.
(I also do a similar exercise on the workbook activate and deactivate)
My question is when the user presses close and the "do you want to save changes" appears, how do I capture if they press cancel, as I want the toolbars to be hidden again
I tried if cancel = true but that seems to be invoked after close has been selected and the warning above appears.
I have a workbook that when it opens it gets all the toolbars that the user has on their screen and makes them invisible and also hides the scrollbars. Thus the page looks like a poster (as it is a snapshot of financial info for mangement).
When the before workbook close method is invoked. The toolbars that the user had on their screen are made visible as are the scrollbars.
(I also do a similar exercise on the workbook activate and deactivate)
My question is when the user presses close and the "do you want to save changes" appears, how do I capture if they press cancel, as I want the toolbars to be hidden again
I tried if cancel = true but that seems to be invoked after close has been selected and the warning above appears.