need macro: convert formula to value
Turn on the macro recorder
then select your cells, format = cells, go to the protection tab and click
both locked and hidden
then protect your worksheet
Turn off the macro recorder.
Look at the recorded code.
--
Regards,
Tom Ogilvy
"moshe" wrote in message
om...
I dont want to see formula at selection area , only values
need macro to do so.
|