Hi Carim,

I understand what you are asking.

The workbook has roughly ten sheets in it. Each sheet has multipl
formats on it. Some are formatted for aphla characters, some fo
numeric and some for commentary (ie, merged cells, wrapped tex
etc...). Each sheet is also password protected.

Not every cell is unique. I guess you could say they are groupe
together in formatting styles. For example, certain cells in rang
A6:C20 are formatted for aplha codes, text. Range D6:G20 has certai
cells formatted for numeric entry. Finally, range A22:E31 is formatte
for commentary.

Due to the multiple formats, I was thinking the answer offered in th
other post might work. When a user selects a cell, the format i
automatically copied somewhere, the user makes their change, then th
macro comapres the new format to the copied original, if they don'
agree, the original format is copied back. I suppose copying th
format of the whole row could work too.

I currently have my nose stuck in a VBA book hping to get a bette
understanding of all this code.

I really appreciate your help!! I you want to see what the spreadshee
looks like let me know, I have no problem attaching it here.

Thanks Carim!
Celt

--
Cel
-----------------------------------------------------------------------
Celt's Profile: http://www.excelforum.com/member.php...fo&userid=1941
View this thread: http://www.excelforum.com/showthread.php?threadid=52363