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

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

Thx,

Quote:

---

Originally Posted by kane

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

Code:

---

Activeworkbook.Save

---

in it, then assign that macro to the shape.

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

Hi there,

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

Code should read:

Code:

---

Activeworkbook.Close

---

It should prompt you if any changes were made.

HTH,

Ok, that was too easy :)


Thx,

Glad to be of help!