I have a collection of associated macros that I thought about turning
into an Add-In.

Can there be worksheets in an Add-In that would contain control
information or templates that could be copied to workbooks?

If so, how to change control values in the add-in and how to copy a
worksheet from the add-in to a workbook.

Also as the add-in evolves any pitfalls to older workbooks such as
incompatible parameters to functions.

Thanks.



*** Sent via Developersdex http://www.developersdex.com ***

Yes the worksheets in the addin can be used for control information etc.

In code you can refer to the sheets in the addin using
Thisworkbook.worksheets("MyTemplate") etc

You can copy formats and data and formulae from the addin template sheet
individually using copy-paste or by copying the worksheet itself.

If the user needs to change control information you would probably be better
off having a separate one-sheet master Control workbook. This can be located
in the same directory as the addin so that it can easily be found and the
system can be moved to a different directory/folder OK.

Charles
______________________
Decision Models
FastExcel 2.1 now available
www.DecisionModels.com

"Edward Ulle" wrote in message
...
I have a collection of associated macros that I thought about turning
into an Add-In.

Can there be worksheets in an Add-In that would contain control
information or templates that could be copied to workbooks?

If so, how to change control values in the add-in and how to copy a
worksheet from the add-in to a workbook.

Also as the add-in evolves any pitfalls to older workbooks such as
incompatible parameters to functions.

Thanks.



*** Sent via Developersdex http://www.developersdex.com ***

I have some issues with Forms and ControlSources to workout. My macros
work with forms, controls and named ranges for control sources. The
ControlSources are on the control worksheet. I am trying to workout
copying this control sheet to the new workbook but have the forms from
the xla tie in to the new worksheet for contol sources.

I am trying to do this with the main form Initialize method which is
obviously flawed from the beginning because to create the form the
control sources have to point to the right worksheet which doesn't exist
yet.

Any suggestions would be helpful.



*** Sent via Developersdex http://www.developersdex.com ***