Adamski
11-12-2009, 04:21 AM
Hello,
I have encountered a strange problem (bug?) with the colour palette (Excel 2003, Win XP Pro SP2 x32). Basically, it gets reset(ish) when opening a workbook which was saved with 2+ windows open. All windows but the last instance have the colours reset when reopening the workbook.
To reproduce, try this:
Open a new workbook.
Set some cells backcolour eg. Red (col1, row3 of default palette)
Go to Tool-Options-Color
Click the colour you used
Click Modify
Click a new colour eg.to Blue
Click OK
Click OK
[Your coloured cells should change colour as expected]
Click Window-New Window (Repeat this if you want)
[New windows show the picked colour]
Save the workbook
close the workbook (all windows)
optional: close excel
open the saved workbook
[Colours reset to default on all but last instance!]
Any solutions? Or is it just me?!
my current workarround is to ensure only one window is open when I save:
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
' Close all but one window of the workbook because otherwise
' the colours get reset when opening again! Stupid Excel
Dim WindowIndex As Integer
For WindowIndex = 1 To ThisWorkbook.Windows.Count - 1
ThisWorkbook.Windows(1).Close
Next WindowIndex
ThisWorkbook.Windows(1).WindowState = xlMaximized
End Sub
but of course this will probably upset the users when theit windows start disappearing!
I have encountered a strange problem (bug?) with the colour palette (Excel 2003, Win XP Pro SP2 x32). Basically, it gets reset(ish) when opening a workbook which was saved with 2+ windows open. All windows but the last instance have the colours reset when reopening the workbook.
To reproduce, try this:
Open a new workbook.
Set some cells backcolour eg. Red (col1, row3 of default palette)
Go to Tool-Options-Color
Click the colour you used
Click Modify
Click a new colour eg.to Blue
Click OK
Click OK
[Your coloured cells should change colour as expected]
Click Window-New Window (Repeat this if you want)
[New windows show the picked colour]
Save the workbook
close the workbook (all windows)
optional: close excel
open the saved workbook
[Colours reset to default on all but last instance!]
Any solutions? Or is it just me?!
my current workarround is to ensure only one window is open when I save:
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
' Close all but one window of the workbook because otherwise
' the colours get reset when opening again! Stupid Excel
Dim WindowIndex As Integer
For WindowIndex = 1 To ThisWorkbook.Windows.Count - 1
ThisWorkbook.Windows(1).Close
Next WindowIndex
ThisWorkbook.Windows(1).WindowState = xlMaximized
End Sub
but of course this will probably upset the users when theit windows start disappearing!