Hi Everyone,

What is the best way to set a template without Rows Limitation?

I've setting up template for my org that I work at for some of the form that
they use will with some built-in formula. The problem that I'm always
encounter is that fact that I have to predict how many rows such template is
going to consist of. And every time, occasionally, that someone needs to
have extra lines for any reason, I have to expand the formula and the
formatting of the rows beyond whatever was originally set.
FYI, I lock the spreadsheet to prevent any change in formula or setting.

Is there a solution for this issue?

Thanks for any advice,
Neon520

i have an idea (but i also have a whopper of a cold, so it may not be
that great of an idea!)........ what if you had a worksheet_change
macro that monitored say, column A, which would in my thought be the
first column that would have info entered. if Target.row was greater
than 500 (for instance), then the worksheet_change macro would
automatically enter your formulas & do the formatting for that row.
you could have it check for the formula before it does it, in case
somebody is doing something back in a row that they had previously set
up via the worksheet_change macro.
like i said, my head is stuffed beyond belief, so take it or leave it.
:)
susan



On Dec 24, 12:20*pm, Neon520
wrote:
Hi Everyone,

What is the best way to set a template without Rows Limitation?

I've setting up template for my org that I work at for some of the form that
they use will with some built-in formula. *The problem that I'm always
encounter is that fact that I have to predict how many rows such template is
going to consist of. *And every time, occasionally, that someone needs to
have extra lines for any reason, I have to expand the formula and the
formatting of the rows beyond whatever was originally set.
FYI, I lock the spreadsheet to prevent any change in formula or setting.

Is there a solution for this issue?

Thanks for any advice,
Neon520