Make a module available to everyone

Hi Sarah,

Thank you for your response.

Do you mean you want the contents of the module available to other modules you have written?

If so you need to have option explicit at the top of the code which forces you to declare your variables as either private or public and declare what data they will hold such as string or integer.

Declaring variables or procedures as public means you can call and use them in all the other modules in your Project Explorer window. If you declare your variables as private(DIM) then those variables can only be called from the current module.

The answer I gave you relates to sharing the code you created with other people in your organisation. As long as you have declared your code correctly you can use this method to then share the module of code with colleagues:

1. Right click on the Module name in the Project Explorer window and choose Export File.

2. Give the file a name and the file extension will be .bas

3. Save the file on a network resource where everyone has access to it.

4. Each of your colleagues then need to open the Visual Basic Editor window(ALT+F8) and choose File and Import File.

5. Navigate to the location of the .bas file, select it and click OK.

The module of code is then copied into the Modules folder of your current workbook. This code can then be copied into the Personal macro Workbook meaning it is available to run on any file you create or open.

I hope this answers your question.

Regards

Simon