Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shared Workbook - insert row and keep validation & format?
Hello,
I have a shared workbook and I am trying to create an easy way to input a new row to enter data. The problem is that I have formula's, list 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 not shared. But when I share the book, the copy/insert works, but the conditional format and list validation are gone. Is there an easier way? Help!! Mike --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
shared workbook - shared workbook options grayed out | Excel Discussion (Misc queries) | |||
Format Change in Shared Workbook | Excel Worksheet Functions | |||
Validation List on a shared workbook | Excel Discussion (Misc queries) | |||
How can I get a validation to run in a macro on a shared workbook? | Excel Discussion (Misc queries) | |||
can't insert row in shared workbook | Excel Worksheet Functions |