Vba code - to ignore conditional formatting

Good Day,

I have a workbook that copies all relevant data from 12 sheets to 1 main sheet.

This data is used purely for reference.

The Code is as follow:

Please Login or Register  to view this content.

It is shared by 13 different people on a Macro enabled sheet just incase you are wondering.

The problem I am having, is that it copies and applies the conditional formating rules of each sheet to the main sheet. This drastically increases my workbook size every time someone opens the main sheet. In 2 days of activity the size of the excel workbook has increased from 2.8mb to a whopping 97 mb. I have tested the sheet for ghosting, and applied formatting to used cells only in the multiple sheets. The problem is truly the conditional formatting to the main sheet.

Is it possible to remove the ability to copy the conditional formatting. Thus removing the problem I am having?

Can my code be adjusted to do this?

Thanking you in advance.

JEDEMEYER1

Thanks Humdingaling,

I added it to the source code, it now looks like this:

Please Login or Register  to view this content.

Works great, until I activate sharing, it then gives me the following error as soon as you view the main sheet: Run-time error '1004': Application-defined or object-defined error.

Did I paste it in the wrong area? Please could you check the code to see.

Thanks again

JEDEMEYER

not having used shared workbooks in past previously
i found as soon as i turned on shared....conditional format was greyed out completely
Did some research on internet and found two MS links explaining limitations of shared workbooks
http://support.microsoft.com/kb/130560
http://office.microsoft.com/en-us/ex...005201080.aspx

This behavior occurs because when you share a workbook file, you cannot use some of the Microsoft Excel features that you normally use. This behavior is by design of Microsoft Excel because of the way that a shared file is saved. For example, you cannot change cell formatting in a shared workbook.

sorry dead end