macros

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Macros

Macros

resolvedResolved · Low Priority · Version 2010

Sally has attended:
Excel Advanced course

Macros

Recording and running macros the system crashed at the training centre and as well as home. Why?
Many thanks

RE: Macros

Hello Sally,

Thank you for your question regarding crashing macros.

Without more information its impossible to work out why the crash happened.

What were you recording at home, at what point did it crash, and if you try it again does it crash at the same point each time? Is it during recording or playback?

If you can describe some of these, then I'll try and work out the reason for the crash.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Mark
Microsoft Office Specialist Trainer

RE: Macros

Hi Mark,
Thank you for reply regarding Macros. When I have finished recording macro and play back or run the macros the sytem crashes. It works twice and then the system crashes.
Can you suggest a simple macro that will work for me in Excel 2010?.
Many thanks
Sally

RE: Macros

Hello Sally,

Can you tell me step by step how you went about recording the macro, what you called it, how you started recording, how you stopped etc..
Then can you tell me exactly what you recorded.. did you record deleting cells, entering text, formatting etc...

It would also help if you could copy and paste the code the macro recorded, so I can read through the code.

Have a great day.
Regards,

Mark
Microsoft Office Specialist Trainer

Wed 24 Aug 2011: Automatically marked as resolved.

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Closing Multiple Open Worksheets At Once

When multiple Excel worksheets are opening, rather than performing a File > Close menu option multiple times, hold down the the SHIFT key and select the File > Close All menu option.

Close All menu option is only displayed when Shift key is down

View all Excel hints and tips


Server loaded in 0.09 secs.