There is code out there for this sort of thing. But it might be easier
to simply copy the data (ctrl+A) to another sheet.
Hi Andy!
Take a trip to:
http://www.mcgimpsey.com/excel/removepwords.html
You can download a workbook that should allow removal of the internal
Excel passwords.

Signature
Regards
Norman Harker MVP (Excel)
Sydney, Australia
njharker@optusnet.com.au
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
> I have passworded one of my spreadsheets but i cannot remember the password
> on this so i cannot edit it anymore is there a way around this?
Andy - 31 Mar 2004 21:56 GMT
Hi Norman
Many thanks that download was cool job done
Regards
Andy
> Hi Andy!
>
[quoted text clipped - 7 lines]
> password
> > on this so i cannot edit it anymore is there a way around this?
Norman Harker - 01 Apr 2004 00:17 GMT
Hi Andy!
Thanks for thanks is always appreciated and shows Google Searchers the
way to go.

Signature
Regards
Norman Harker MVP (Excel)
Sydney, Australia
njharker@optusnet.com.au
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.