rubu2
asked on
Excel spreadsheets coming up with weird colors randomly.
I have a user that has windows XP SP2,running office 2k3. She is having an issue randomly where the excel page will open with the colors being off. Some parts will have weird colors like green. She can open this document again and then everything will be fine.
Is this only happening on one install/one user?
If so - get her to log out - and delete the user's Application Data folder on the roaming profile (if you are using those - e.g. on a domain) and also on the local workstation.
C:\Documents and Settings\<user name>\Application Data\Microsoft
If so - get her to log out - and delete the user's Application Data folder on the roaming profile (if you are using those - e.g. on a domain) and also on the local workstation.
C:\Documents and Settings\<user name>\Application Data\Microsoft
If that doesn't help - try running Detect and Repair from any Office spp, Help menu, Detect and Repair...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Xanius,
Just for my education - does that array define the standard colour palette? & if it does where did you get it from?
Patrick
Just for my education - does that array define the standard colour palette? & if it does where did you get it from?
Patrick
Patrick,
Yes, it is the default colour palette. I read it out of excel itself:
Sub ListColors()
Dim c
For Each c In ActiveWorkbook.Colors
Debug.Print c & ", ",
Next
Debug.Print
End Sub
Cheers
Xanius
Yes, it is the default colour palette. I read it out of excel itself:
Sub ListColors()
Dim c
For Each c In ActiveWorkbook.Colors
Debug.Print c & ", ",
Next
Debug.Print
End Sub
Cheers
Xanius
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Xanius,
I've been thinking about this and there is a much simpler way. It's this:
Sub resetpalettecolours()
ActiveWorkbook.ResetColors
End Sub
Patrick
I've been thinking about this and there is a much simpler way. It's this:
Sub resetpalettecolours()
ActiveWorkbook.ResetColors
End Sub
Patrick
Patrick,
generally you're right. In the normal case .ResetColors woks. But I've had bunch of spreadsheets coming form our controlling which screwed up my excel in such a way (Don't ask me how), that I had to do it the hard way. So I wrote the macro and put it in my PERSONAL.XLS and linked it to a Button on a taskbar.
Cheers Xanius
generally you're right. In the normal case .ResetColors woks. But I've had bunch of spreadsheets coming form our controlling which screwed up my excel in such a way (Don't ask me how), that I had to do it the hard way. So I wrote the macro and put it in my PERSONAL.XLS and linked it to a Button on a taskbar.
Cheers Xanius
rubu2 - Please excuse our asides...
Xanius,
That's intriguing. By the way I have tried using personal.xls and I find it a total pain. I think I must be doing something wrong as I have given it up altogether and deleted it from my machine.
Patrick
Xanius,
That's intriguing. By the way I have tried using personal.xls and I find it a total pain. I think I must be doing something wrong as I have given it up altogether and deleted it from my machine.
Patrick
Did you manage to find an answer to this?
If so - is she clicking "Allow macros"?