Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft+excel+training - Assigning macros

microsoft+excel+training - Assigning macros

ResolvedVersion Standard

Wed 9 May 2007, 09:47 Delegate Kara said...

Kara has attended:
Excel Advanced course
Excel VBA Intro Intermediate course

Assigning macros

would like to know how to get a spreadsheet / model to run several cases / sensitivities using a macro instead of runing them manually

Tue 5 Jun 2007, 13:02 Trainer Andrew said...

RE: Assigning macros

Hi Kara

Thank you for your question - before I can forward it to a trainer could you give some additional information about how you would like the model to work?

Thanks

Andrew

Tue 5 Jun 2007, 13:07 Delegate Kara said...

RE: Assigning macros

thanks for the reply. i figured it out myself!

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Showing all menu items

If you go into a pull down menu you usally find that you get a selection of items(this is the default) or sometimes everything. If you only get a selectiopn you have to go to the double arrows at the bottom of the menu and click it to get all of the hidden items.
To turn this off so that you always get everything, go to Tools / Customize / Options Tab / "Always show full menus". Make sure there is a tick in the box and you will always have every item.

View all Excel hints and tips

microsoft+excel+training - Assigning macros

Assigning macros

RE: Assigning macros

RE: Assigning macros

Excel articles

Excel tip:

Showing all menu items