PDA

View Full Version : Solved: cancel on close workbook



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.

Bob Phillips
02-28-2008, 12:43 PM
Cancel allows you to cancel it.

You need to throw up your own message, and if they say no, set Cancel=true and not hide the toolbars and exit, otherwise save it and hide the toolbars.