add-in?

[ex1302]

Hi all,

The problem:

I have built a happy little process whereby if a user selects a certain value from a data validation list embedded in the sheet, a seperate userform will open for each value. This relies on the specific sheet "Worksheet_Change" to drive the functions.

This works fine as it is all in the same place, however the powers that be have decided that this needs to be added to a seperate new workbook each time an admin downloads a specific report, and this is where I am stuck!

How can I get this code to be portable to other workbooks?

I have exported the main code (inc all the forms) as a excel add-in but i have to physically run a macro to initialise the open form code after each change in each cell!

I was hoping the add-in would include the chance of adding the data valdation or providing an additional button, and it is this part i am confused about:

If the work book is fresh how will I get the data validtion in without the user having to doing too much?

How can I then get the data validation to trigger the open form code?

Or get the openform code behind the new sheet?

Sorry for the essay,

Thanks

Andy

[Bob Phillips]

See response in programming.

--
HTH

Bob Phillips

"ex1302" <ex1302.1s5jmq_1121331975.19@excelforum-nospam.com> wrote in
message news:ex1302.1s5jmq_1121331975.19@excelforum-nospam.com...
>
> Hi all,
>
> The problem:
>
> I have built a happy little process whereby if a user selects a certain
> value from a data validation list embedded in the sheet, a seperate
> userform will open for each value. This relies on the specific sheet
> "Worksheet_Change" to drive the functions.
>
> This works fine as it is all in the same place, however the powers that
> be have decided that this needs to be added to a seperate new workbook
> each time an admin downloads a specific report, and this is where I am
> stuck!
>
> How can I get this code to be portable to other workbooks?
>
> I have exported the main code (inc all the forms) as a excel add-in but
> i have to physically run a macro to initialise the open form code after
> each change in each cell!
>
> I was hoping the add-in would include the chance of adding the data
> valdation or providing an additional button, and it is this part i am
> confused about:
>
> If the work book is fresh how will I get the data validtion in without
> the user having to doing too much?
>
> How can I then get the data validation to trigger the open form code?
>
> Or get the openform code behind the new sheet?
>
> Sorry for the essay,
>
> Thanks
>
> Andy
>
>
> --
> ex1302
> ------------------------------------------------------------------------
> ex1302's Profile:
http://www.excelforum.com/member.php...o&userid=25217
> View this thread: http://www.excelforum.com/showthread...hreadid=387086
>