Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

marcos

ResolvedVersion 2003

Candice has attended:
Excel Advanced course

Marcos

While in the process of recording a Marco and a file is accidentally closed, is it possible that the macro would automatically "stop" recording at that point and have saved the data?

RE: Marcos

Hi Candice

Thanks for your question.

I'm afraid the answer is probably no. If the file was closed without saving, then the macro would be lost. If however you did accidentally close it, you would be prompted to save the file.

Regards

Stephen

Wed 25 Aug 2010: Automatically marked as resolved.

Excel tip:

Wrapping Text in a Cell in an Excel 2010 Workbook

When you have a lot of text you want to put in a particular cell but you can't decrease the font size to fit because the text will then become ineligible, then manually wrap the text in a cell by simply pressing ALT+ENTER.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.