Posted by RoB on August 13, 2001 4:03 PM
Im looking for a way to do 2 things (totally separate).
First, I was wondering if there is a way (probably a macro) to:
when the close workbook, or close excel button is clicked, ask the user a question, and give them a "yes" or "no" option. If they click yes, I would like the close to proceed, and ask if they would like to save their changes. If they click no, I would like the macro to take them to the first sheet of the workbook.
Also, I was wondering (probably a macro again) to:
Give a shape a conditional color.
ie: If a certain cell is empty, I would like the shape I place to NOT filled, with NO lines (invisible). But if the certain cell has data, then the line to be black (still no fill).
I appreciate any help on these questions.
Thanks again :)