Hi

I am creating a formal document (annual accounts) in Excel and while
working on the Excel file want the page footers to print but need to be
able to suppress the footers to show the draft pages as they will look
finally. I am doing this by printing the footer “white-on-white”. I then
want to revert to having the original footers by having black font in
the footer.

So I will use code along the lines:
..LeftFooter = "&K00+000”&.LeftFooter

but need to be able to eliminate any previous “&K..” coding in the
original .LeftFooter, which Excel does automatically when changing the
code manually.

Can someone tell me how to eliminate programmatically any previous font
colour coding in the footer?

Many thanks

Tim