Hi,
Months ago I created a xlsm-file in Excel 2010 for our secretariat. I used vba to implement several formatting conditions used to signal certain values with a color. Every time the workbook is opened all conditions are 'refreshed' (deleted and implemented again). Everything worked fine, but today one of the secretaries mailed me that suddenly all colors were disappeared without any error-message. The file is on the network, so I opened the file on my own computer. Everything worked fine, all colors were correctly displayed. At her computer I runned the sub Workbook_Open by hand, but still no colors where visible. Then I checked if there were formatting conditions impletented and there were, so the code seem to run well. But they have no effect in the data. I realy have no clue what's going wrong here, so I woul realy appreciate any help.
best regards,
Liselot
Months ago I created a xlsm-file in Excel 2010 for our secretariat. I used vba to implement several formatting conditions used to signal certain values with a color. Every time the workbook is opened all conditions are 'refreshed' (deleted and implemented again). Everything worked fine, but today one of the secretaries mailed me that suddenly all colors were disappeared without any error-message. The file is on the network, so I opened the file on my own computer. Everything worked fine, all colors were correctly displayed. At her computer I runned the sub Workbook_Open by hand, but still no colors where visible. Then I checked if there were formatting conditions impletented and there were, so the code seem to run well. But they have no effect in the data. I realy have no clue what's going wrong here, so I woul realy appreciate any help.
best regards,
Liselot