Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Macros

Resolved · Low Priority · Version 2010

Reply Tue 16 Aug 2011, 11:10Delegate Sally said...

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

For upcoming training course dates see: Pricing & availability

Reply Wed 17 Aug 2011, 09:25Trainer Mark said...

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

Reply Wed 17 Aug 2011, 16:38Delegate Sally said...

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

Reply Wed 17 Aug 2011, 20:27Trainer Mark said...

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.

Excel articles

· How To Identify The Most Critical Data In A Large Excel Spreadsheet
· Want To Use Excel To Calculate Your Mortgage Repayments?
· From novice to expert users - Microsoft Excel fits all
· How To Insert, Delete, Format, Hide, Copy And Protect Worksheets In Excel
· What's In A Number? Make Figures Mean More Via Excel

Please browse our web site to find out more about
introduction excel training and other Microsoft training courses.

Excel tip:

Recently used file list

Under the File menu, you may find a list of files at the bottom of the menu. These files represent the most recently used Excel spreadsheets. This file list provides a quick way for you to access your files.

You can disable the file list feature of Excel. This is done by

1. Choose Tools > Options menu. You will see the Options dialog box.
2. Ensure the General tab is selected.
3. Make sure the Recently Used File List check box is cleared.
4. Click on OK.

View all Excel hints and tips