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

See response in programming.

--
HTH

Bob Phillips

"ex1302" wrote in
message ...

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