A
amepluie
Hi All,
I have a worksheet with Subtotal function for several Groups.
The idea is the user can enter the data then the subtotal function can
calculate the SUM/COUNT or whatever.
So I want to lock the lock the SUBTOTAL row (so the user come mess it
up), which is easy enough to do.
the problem comes....
I have a large groups of subtotals so naturally I want to show the
outline at high level and user can expand to which data group they
want to enter in. But seems any lock within the outline will block
that?
Is there a way around it?
Would really appreciate someone's help!!!
Thanks,
Kerry
I have a worksheet with Subtotal function for several Groups.
The idea is the user can enter the data then the subtotal function can
calculate the SUM/COUNT or whatever.
So I want to lock the lock the SUBTOTAL row (so the user come mess it
up), which is easy enough to do.
the problem comes....
I have a large groups of subtotals so naturally I want to show the
outline at high level and user can expand to which data group they
want to enter in. But seems any lock within the outline will block
that?
Is there a way around it?
Would really appreciate someone's help!!!
Thanks,
Kerry