View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John Guderian John Guderian is offline
external usenet poster
 
Posts: 2
Default 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!