I am a beginner in Excel programming. There are a bunch of
cells with colored borders and colored background. I
programmed a button to clear all of the colored borders
and background for certain purpose. My question is at the
end of the program, I need to find some ways to restore
the original colored borders and background. How to
achieve and restore that?

Thanks all!

Chris

You would need to loop through them all, save the details, and restore
afterwards.

Why not just leave 'em be? Try ClearContents instaed of Clear.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Chris" wrote in message
...
I am a beginner in Excel programming. There are a bunch of
cells with colored borders and colored background. I
programmed a button to clear all of the colored borders
and background for certain purpose. My question is at the
end of the program, I need to find some ways to restore
the original colored borders and background. How to
achieve and restore that?

Thanks all!

Chris

Hi Bob, Thanks a lot! I am new and sorry for my ignorance.
How do you just save a few cells' borders and background
within a big Excel file and then restore those borders and
background? Do you have any sample code for that?
Chris

-----Original Message-----
You would need to loop through them all, save the
details, and restore
afterwards.

Why not just leave 'em be? Try ClearContents instaed of
Clear.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Chris" wrote in message
...
I am a beginner in Excel programming. There are a bunch
of
cells with colored borders and colored background. I
programmed a button to clear all of the colored borders
and background for certain purpose. My question is at
the
end of the program, I need to find some ways to restore
the original colored borders and background. How to
achieve and restore that?

Thanks all!

Chris



.