chris12345
New Member
- Joined
- Jun 27, 2005
- Messages
- 35
Hi,
I have a macro in a workbook that other colleagues use. Part of the macro copies the data into a new workbook. Most have no issue, but with a few colleagues it changes the cell colour (Red, Accent 2, Lighter 60% in the cell colour pallette [R230, G184, B183]) to a sort of orange colour...but not all columns bizarrely. A previous search suggests this is due to the version of MS Office being used and by adding the below to the macro would solve it. It did for a while, but now it is crashing the macro - difficult to ascertain if its all the same people or just some.
ActiveWorkbook.Theme.ThemeColorScheme.Load ( _
"C:\Program Files\Microsoft Office\Root\Document Themes 16\Theme Colors\Office 2007 - 2010.xml" _
)
I would rather keep the colouring as it works nicely aesthetically so if there is a simple update I could get affected colleagues to run on their machine that would be great. I need a stable workbook, so would consider changing the colour to a more generic one, but I do not know which ones won't get changed depending on which machine the macro is being run with.
Any help greatly appreciated
I have a macro in a workbook that other colleagues use. Part of the macro copies the data into a new workbook. Most have no issue, but with a few colleagues it changes the cell colour (Red, Accent 2, Lighter 60% in the cell colour pallette [R230, G184, B183]) to a sort of orange colour...but not all columns bizarrely. A previous search suggests this is due to the version of MS Office being used and by adding the below to the macro would solve it. It did for a while, but now it is crashing the macro - difficult to ascertain if its all the same people or just some.
ActiveWorkbook.Theme.ThemeColorScheme.Load ( _
"C:\Program Files\Microsoft Office\Root\Document Themes 16\Theme Colors\Office 2007 - 2010.xml" _
)
I would rather keep the colouring as it works nicely aesthetically so if there is a simple update I could get affected colleagues to run on their machine that would be great. I need a stable workbook, so would consider changing the colour to a more generic one, but I do not know which ones won't get changed depending on which machine the macro is being run with.
Any help greatly appreciated
