Cell formatting through VBA
 

Ive got a spreadsheet that has cells formatted for a particular use with
borders, etc. This sheet is also going to be used by a 2nd group of people
who need to have the formatting removed yet can use all the same fields.

I have created a command button that removes the cell contents, and borders
from a specific range of cells, which works great. However, Id like to be
able to have an additional command button that reverts the formatting, and
cell values that way they were originally. Is there a way to do this?

Thanks!

Cell formatting through VBA
 

Turn the macro recorder on, go through all of the steps to add that
formatting, and you have your macro.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"John Guderian" wrote in message
...
Ive got a spreadsheet that has cells formatted for a particular use with
borders, etc. This sheet is also going to be used by a 2nd group of people
who need to have the formatting removed yet can use all the same fields.

I have created a command button that removes the cell contents, and
borders
from a specific range of cells, which works great. However, Id like to be
able to have an additional command button that reverts the formatting, and
cell values that way they were originally. Is there a way to do this?

Thanks!