aMeek
New Member
- Joined
- Nov 19, 2010
- Messages
- 12
My apologies in advance if I don't use correct terminology, I'll do my best to relate what I'm seeing. I have an Excel file that is the output of a macro on another Excel file. If If I'm using Excel with other files, and I open this output file as well, the background colors on my originally open files will change.
If, after this change, I close the changed files and the output file, and reopen the changed files in that instance of Excel, the colors are still changed.
If I fully close that instance of Excel, and open the original files in a new instance of Excel, the colors have then reverted to their original colors.
Checking the cell format option before and after opening the file, it looks like three of the cell shading colors change. I'm using one of these colors, so it then changes the color on the sheet.
In the macro, I use a lot of variations of
If ActiveCell.Value = "B536P " Then
Selection.Interior.ColorIndex = 54
Selection.Font.ColorIndex = 2
Selection.Font.Bold = True
I'm using Excel 2003, SP3.
Any ideas, or more information needed?
If, after this change, I close the changed files and the output file, and reopen the changed files in that instance of Excel, the colors are still changed.
If I fully close that instance of Excel, and open the original files in a new instance of Excel, the colors have then reverted to their original colors.
Checking the cell format option before and after opening the file, it looks like three of the cell shading colors change. I'm using one of these colors, so it then changes the color on the sheet.
In the macro, I use a lot of variations of
If ActiveCell.Value = "B536P " Then
Selection.Interior.ColorIndex = 54
Selection.Font.ColorIndex = 2
Selection.Font.Bold = True
I'm using Excel 2003, SP3.
Any ideas, or more information needed?