View Full Version : [SOLVED:] 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,
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.
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,
Ok, that was too easy :)
Thx,
Ken Puls
05-25-2005, 09:46 PM
Glad to be of help!
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.