PDA

View Full Version : [SOLVED] Click AutoShape and close the workbook w/ option to save.



kane
05-25-2005, 04:40 PM
I would like to click an autoshape drawing and have the workbook close with the option to save or not.

Thx,

Bob Phillips
05-25-2005, 04:53 PM
I would like to click an autoshape drawing and have the workbook close with the option to save or not.

Create a simple macro with


Activeworkbook.Save

in it, then assign that macro to the shape.

kane
05-25-2005, 07:14 PM
Thx, but not really what I need.

I want to click the drawing and have the workbook close and the dialog
box("Do you want to save the changes you made to abc.xls? Yes, No, Cancel") come up and give me the option to save or not.

:yes

Ken Puls
05-25-2005, 07:19 PM
Hi there,

Just change it a little, but still assign it to a shape.

Code should read:



Activeworkbook.Close

It should prompt you if any changes were made.

HTH,

kane
05-25-2005, 07:35 PM
Ok, that was too easy :)


Thx,

Ken Puls
05-25-2005, 09:46 PM
Glad to be of help!