The problem with any of the approaches suggested (including mine) is that
one can copy a cell with a different format, and have it copied to the
unlocked cells. You could force the user NOT to copy a cell by probably
unchecking the select locked cells option, but that would still not be fool
proof.
format >Unlock all cells user is allowed to access>format your cell>PROTECT the
sheet to allow values>
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Ayush Jain
Sent: Friday, October 21, 2011 12:45 AM
To: excel-macros
Subject: $$Excel-Macros$$ Restrict cell format not values
Hello
