[RESOLVED] Conditrional formatting and shared workbook

[Resource Dragon]

I have written some code which inserts a row into an excel spreadsheet and then copies various things, including formats, from the row above. * My thanks to other posters on the subject of row insertion.

Everything worked fine when I tested it. The problem arose when I went to use it for real - because the file is shared and, of course, I had removed the file from shared use when I was coding and testing.

I think the problem came in with the condtional formatting: as the existing rows in the worksheet have conditional formats.

How do I fix this problem? Do I need to remove the conditional formatting and write it into the VBA code? Or is there some way that I can tell excel to allow the row insertion and format copying?

[Siddharth Rout]

Or is there some way that I can tell excel to allow the row insertion and format copying?

Is the workbook protected and then shared? If yes then before protecting, when you get the box to enter the password, scroll down the list and click on "Insert rows". See picture attached and then share the workbook.... Same is the case for any formatting...

Hope this helps...

[Resource Dragon]

Hey, koolsid, thanks for that. I also played around with formats > cells > protection & unlocked everything and it's working now.
Cheers, Resource Dragon.