Thanks chaps.

Bob, Yours worked but locked cells that didnt contain formulas. Ha
would I change the macro so that cells with formulas are locked?

Jim, couldnt get yours to work.

Will these both work with excel 97?

Thanks again

--
tanktat
-----------------------------------------------------------------------
tanktata's Profile: http://www.excelforum.com/member.php...nfo&userid=459
View this thread: http://www.excelforum.com/showthread.php?threadid=55910