VBA

Resolved · Low Priority · Version 2003

Wed 30 Jul 2008, 16:26 Delegate Elaine said...

Elaine has attended:
Excel VBA Intro Intermediate course

VBA

When creating code in one workbook how do you make it available to other workbooks?

Fri 1 Aug 2008, 11:34 Trainer Carlos said...

Make Code Available

Hi Elaine

If code is written in the Personal Macro Workbook it can be used by all workbooks that are opened on your computer.

Also, if Procedures(Macros) created in any workbook are preceded by the word Public (eg Public Sub MyMacro() ) then they will be visible by all open workbooks.

The danger of writing code in one workbook (Book A) to be used in another workbook (Book B), is that Book A has to be open on the computer for Book B to be able to use the code.

This means that if Book B is sent to someone else they can't run any of the code.

As a good practice I always advise people to copy the code into all the workbooks that will be using it.

It may be duplication of code but will save hours of frustration in the long term.

Regards

Carlos