Need to remove a password that noone placed on Excel worksheet.

We had an Excel worksheet that is used everyday suddenly pop up with
protection. I have used protection before, but this one never had a
password. We put in every known password we use, but none worked. I
resigned to re-typing the worksheet, then, inbetween Friday night, and
Saturday noon, when most of the office is out, a different Excel worksheet
has the same problem. We are using Excel 97. Any help would be appreciated.

Hi Tuffy,

See JE McGimpsey's RemovePassword page at:

http://www.mcgimpsey.com/excel/removepwords.html


---
Regards,
Norman



"tuffy1104" <[email protected]> wrote in message
news:[email protected]...
> We had an Excel worksheet that is used everyday suddenly pop up with
> protection. I have used protection before, but this one never had a
> password. We put in every known password we use, but none worked. I
> resigned to re-typing the worksheet, then, inbetween Friday night, and
> Saturday noon, when most of the office is out, a different Excel worksheet
> has the same problem. We are using Excel 97. Any help would be
> appreciated.

You might try hooking up a video camera to catch the joker.

--
Don Guillett
SalesAid Software
[email protected]
"tuffy1104" <[email protected]> wrote in message
news:[email protected]...
> We had an Excel worksheet that is used everyday suddenly pop up with
> protection. I have used protection before, but this one never had a
> password. We put in every known password we use, but none worked. I
> resigned to re-typing the worksheet, then, inbetween Friday night, and
> Saturday noon, when most of the office is out, a different Excel worksheet
> has the same problem. We are using Excel 97. Any help would be
appreciated.

I had the same issue, the macro on McGimpsey's RemovePassword page works like a charm.