Excel providing numerous end users with form and underlying code

[DougP]

I created a form which looks at several tabs to get the data.
I put the code in a module and some is in the forms VBA code.
This module code and form are in my Personal.xlsb file. I also created a button on the Quick Access Toolbar that launches the form.
What is the easiet way to distribute this to the end users? so the user have the button and the form and code to make it all happen without having to turn on the developer tab, paste in the code. import the form file, create a personal.xlsb file in Excel 2007. etc etc.


TIA

DougP

 

[SkipVought]

hi,

Rather than having the form, sheets & code code in YOUR personal.xlsb workbook, why not have all of it in a separate workbook that the user can access from your network?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[DougP]

The users are world wide and they currently don't have access, but we are moving toward that. This is an interum solution.

DougP

 

[SkipVought]

Well how do you propose to distribute?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[DougP]

email out to them? or they many be able to download it. I'm not 100% sure. I'm just in charge of making a solution. The managers will distribute it.

DougP

 

[SkipVought]

You choose. Either eMail the workbook or a link on the network.

Either way, ALL the forms and code must be in the workbook.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[DougP]

How, when I put the code in the workbook and not the Personal.xls.. I get a warning or error saying it is not set to run macros.

DougP

 

[SkipVought]

You workbook must be SaveAs a Macro-Enabled Workbook (.xlsm)

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}