Good morning Sweetsue516

Try this:

Open your file. Create a blank new workbook. For each sheet in your
protected workbook, click in the top left hand corner to highlight the
whole sheet, right click and copy and then cross to the new workbook
and copy your sheets in one by one. Then save your newly recreated
sheet. If you've got a number of sheets it might be a bit of a pain
and you may lose some aspects like custom views, or complicated
formulae referencing external sources, but if you've got a relatively
simple straightforward workbook it should be OK.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=398646