Click AutoShape and close the workbook w/ option to save.

[kane]

I would like to click an autoshape drawing and have the workbook close with the option to save or not.

Thx,

[Bob Phillips]

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]

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.

[Ken Puls]

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]

Ok, that was too easy


Thx,

[Ken Puls]

Glad to be of help!