E
Eager2Learn
Hello,
I have a shared workbook and I am trying to create an easy way to inpu
data without using a form. The problem is that I have formula's, lis
validation, and conditional formatting in all rows.
I created a macro that would copy row 3 and then 'insert copied cells
and clear out the data. This works perfect when the workbook is no
shared. But when I share the book, the copy/insert works, but th
conditional format and list validation are gone. I realize that yo
lose Validation and Conditional formatting while is Shared mode.
Currently, I have to copy the formulas, formatting and validation dow
a long way and my file is HUGE....filled with a lot of current blan
rows (but with the formulas and such in them).
Is there an easier way? Help...I am totally stuck
I have a shared workbook and I am trying to create an easy way to inpu
data without using a form. The problem is that I have formula's, lis
validation, and conditional formatting in all rows.
I created a macro that would copy row 3 and then 'insert copied cells
and clear out the data. This works perfect when the workbook is no
shared. But when I share the book, the copy/insert works, but th
conditional format and list validation are gone. I realize that yo
lose Validation and Conditional formatting while is Shared mode.
Currently, I have to copy the formulas, formatting and validation dow
a long way and my file is HUGE....filled with a lot of current blan
rows (but with the formulas and such in them).
Is there an easier way? Help...I am totally stuck