If you protect the worksheet (tools|protection|protect sheet), then that should
stop most attempts.
But if the user is copy|pasting from a difference source, then I don't think you
can stop them.
Maybe you could just reapply the format when you want--right before they save or
each time they reopen the workbook???
TEAM wrote:
Anyone know how to disable an excel user from changing the format of my
spreadsheet? I have some cells that are unlocked because the user must
input in to those cells, but I do not what that person to modify the
format of anything on the sheet.
THANKS!!
--
TEAM
------------------------------------------------------------------------
TEAM's Profile: http://www.excelforum.com/member.php...o&userid=22810
View this thread: http://www.excelforum.com/showthread...hreadid=491977
--
Dave Peterson