Inset new row in Shared Workbook & keep formatting & Validation?

  • Thread starter Thread starter Eager2Learn
  • Start date Start date
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
 
Hi,
Please help... No one seems to be able to help me with this and m
excel spreadsheet is getting too big and takes too long to open...
Thanks
 
Back
Top