basic excel training - macro workbook

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » basic excel training - Macro workbook

basic excel training - Macro workbook

resolvedResolved · Low Priority · Version Standard

Macro workbook

When we created a macro yesterday we used it two ways. One we created a shortcut key in the "This workbook" and then we next attached it to a personal toolbar and used it from a button with the macro assigned to it Another option when using the shortcut key was "Personal Workbook" - I often need the same macro in different workbooks so would it be better to store my macros in a personal workbook - how does this then work?

RE: Macro workbook

By storing the Macro in a personal workbook, you will be able to use the macro across all new and existing spreadsheets.

RE: Macro workbook

Would that mean that I would always need to remember to open my personal workbook when I open excel and if so can I automate this?

RE: Macro workbook

No it will open with the application. For example, if you created a macro button on the toolbar, it will stay there everytime you open up Excel.


 

Excel tip:

Sorting data stored in rows

Primarily Excel is set up to sort data that is stored in columns rather than rows.

It is possible to get Excel to sort data stored in rows however.

Click in the row you want to sort, or select the cells in the rows you wish to sort.

Go to Data - Sort, then go to the Options button in the bottom left corner of the Sort dialogue box.

View all Excel hints and tips


Server loaded in 0.07 secs.