Hello,

So I have this workbook that is used as a template (Template A) for users, and when it opens, it automatically shoots an input box to ask for the number of lines the user will need in the template.

However, i have to make another template (Template B) that will use a different layout for special cases... however, it all needs to be stored in Template A's layout as well...

So, when i try to open Template A from Template B with a macro, i will need to specify the number of lines for Template A in its input box. The number of lines i need to input i can have it stored in a variable in Template B.

So, is there a way to tell Template A to use Template's B variable as the input for the input box?
Thanks