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 2007

Ashley has attended:
Excel Advanced course

Macros

How do I copy macros into a new workbook?

RE: Macros

Hi Ashley

Thanks for your post - sorry for the late reply

there is 2 easy ways to get marco's in a new workbook 1. open the create the macro in the file you are in and when you start creating this choose to store it in your personal macro work book - this will enable you to use this in any workbook, or 2. go into the macro you want to copy, and when you are in the macro editer you can copy and paste the macro into VBA for the new workbook

Hope this helps

If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn

Wed 14 Jan 2009: Automatically marked as resolved.


 

Excel tip:

The Easiest and Quickest Way to use Autosum in Excel 2010

Autosum is used frequently in Excel. As with almost every feature of Excel, there are more ways than one to use each feature. Below is the simplest way to use the Autosum feature.

1) Go to the bottom of the column of data.

2) Shortcut click in the column then Ctrl + down arrow

3) Use Alt + = for Autosum and press the enter key to complete.

View all Excel hints and tips


Server loaded in 0.08 secs.