Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel microsoft training - Excel Macros

excel microsoft training - Excel Macros

ResolvedVersion Standard

Wed 10 Oct 2007, 16:04 Delegate Ben said...

Ben has attended:
Excel Advanced course

Excel Macros

When recording a macro can I open up seperate folders & Documents that links back to current worksheet?

Thu 11 Oct 2007, 14:30 Trainer Pete said...

RE: Excel Macros

Hi Ben, Thanks for the post. Yes you can record a macro which will open different documents, the macro will record your mouse clicks and key strokes and replay them when you call it up, however it may be useful as an alternative to create a Workspace icon which includes all the linked workbooks and then record a macro to open the workspace icon, which will simplify it considerably.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Entering text in Multiple Worksheets

If you have a number of worksheets in a workbook that require the same information (data or tables) on each worksheet, this can be done as follows:

Hold down the Ctrl key and click one or more of the additional worksheet tabs (i.e. Sheet2, Sheet3, etc).

In your mainsheet (Sheet1) enter the required data or design a table.

When done 'Click' on the other sheet tabs and you will see that the information entered in Sheet1 is on all the other selected worksheets.

NB Do not forget to deselect the worksheets - otherwise you may add data to the main worksheet and all the selected worksheets will also have that data!

View all Excel hints and tips

excel microsoft training - Excel Macros

Excel Macros

RE: Excel Macros

Excel articles

Excel tip:

Entering text in Multiple Worksheets