Unprotect a worksheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Damien - 10 Jun 2004 10:30 GMT

I've been given a excel workheet by a colleague, but I need to make changes, but the worksheet has a password on it, how do i get around this.

Reply to this Message

Norman Harker - 10 Jun 2004 11:13 GMT

Hi Damien!

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

Signature

Regards
Norman Harker MVP (Excel)
Sydney, Australia
njharker@optusnet.com.au

> I've been given a excel workheet by a colleague, but I need to make
> changes, but the worksheet has a password on it, how do i get around
> this.

Reply to this Message

FRAZZLED - 30 May 2006 17:06 GMT

HELP!!! I created a worksheet and protected the cells with formulas. I now
need to edit the column and row names and I am unable to unprotect the sheet
to work on it. The options are grayed out and it does not ask for my
password. I need this today.

> I've been given a excel workheet by a colleague, but I need to make changes, but the worksheet has a password on it, how do i get around this.

Reply to this Message