Changing highlight color of workbook changes?

[Sypher2]

I have a shared workbook. An unattended Visual Basic program will have it open and people can open the workbook to view changes it is making.

When changes are made, there is a highlighted border around the changed cells. Currently the color of this highlighted border is a drab brownish color.

Is there any way to change this color to red or some other high visibility color? I'm thinking I may be out of luck, but was hoping there was perhaps an obscure way to do it. Thanks.

 

[SkipVought]

Sypher2,
Are you saying that a VB program OPENS this Excel application. If that's the case then it may be in that VB program - and only someone who has the source can change what you want.

On the other hand, there may be a VBA procedure in the application that emphasizes changes.

When you open this application, do you have to Enable Macros?

If the answer is "NO," then read no further.

1. On the sheet that has this feature, right click the tab and select view code - this opens the VB Editor
2. Is there any code visible on that sheet?
3. Key cntl+r - Is there a Module in the Project Explorer?
4. Report your findings Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[SkipVought]

It could also be Conditional Formatting which is a spreadsheet feature Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[Sypher2]

I created the VB app and the shared workbook myself.

The highlight for changed cells is a feature of a shared workbook. Whenever a user makes a change to a cell, that cell gets highlighted to all other users. You can hover the mouse over the cell to see information (like a comment).

If several people are making changes, each user has a different color highlight. I'm wondering if there's any way to manipulate or choose the highlight color.

 

[SkipVought]

If there's nothing in Tools/Options, I haven't a clue -- sorry :-( Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com