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

M

miker1999

Hello,
I have a shared workbook and I am trying to create an easy way to inpu
data. The problem is that I have formula's, list validation, an
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.

Is there an easier way? Help!!
Mik
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top