Re: Get Active Window Title Bar Color
doesn't work in xl97 (I confirmed the error). I think it's the part bolded in red that's the problem.
Yes Andy, I think when you read Chris' final post (which he posted while I was posting) then I think that despite what he said
Quote from chrisxs5
to me earlier
Quote from Barbarr
I could be wrong and we'll have to get the OP to clarify but I read got the feeling that he wanted the colour to automatically match the colour of the active window title bar, based on what the user's colour scheme for Windows. This would be similar to selecting a colour on a userform based on the title bar colour.
it's whatever is pre-selected for the Color Fill icon on the Formatting toolbar.
Ain't terminology wonderful (but only if we all share the same meaning of it).