obviously I would validate that the open workbook is one that I want to add a
form to... I am by no means a reckless programer!

--
Simon Shaw, CA
President
Kode101 Inc.
www.kode101.com


"Jon Peltier" wrote:

You want to add a form to every open workbook on your users' computers? What
if the workbook they are currently using has nothing to do with your form?
If you wrote code that tried to add VB components to workbooks on my
computer, it would be the last code of yours I'd ever run.

Write an add-in that contains and controls the form, make it accessible from
every relevant workbook, then distribute it so the users install it as an
add-in.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Simon Shaw" <simonATsimonstoolsDOTcom wrote in message
...
Hi,

I need to add a form to multiple workbooks.

I have the form saved on a network drive and I need to build a workbook to
email out users so they can click a button and it will run code to add a
form
to their open workbooks. Is this possible?

Thanks

Simon Shaw
www.kode101.com