Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Unprotecting a worksheet

3 views
Skip to first unread message

Jessica

unread,
Jun 3, 2008, 4:26:05 PM6/3/08
to
I have a file that was not originally protected and for some reason now is. I
tried to unprotect, however, it is greyed out. This workbook has macros as
well. Not sure how to handle this.

Mike H

unread,
Jun 3, 2008, 4:39:01 PM6/3/08
to
Hi,

It sounds like this is a shared workbook. Unshare with
Tools|Share workbook and remove the checkmark

You should then be able to unprotect

Mike

Gord Dibben

unread,
Jun 3, 2008, 5:05:40 PM6/3/08
to
Worksheet protected or Workbook protected?

You use both terms and the word "file" in your description.

What exactly is protected?

Unprotecting is quite dependent upon what you have protected and do you need a
password?

If the workbook is shared, you cannot unprotect a worksheet or workbook under
Tools>Protection.

If you have multiple sheets selected you cannot unprotect sheets but you can
unprotect the workbook.


Gord Dibben MS Excel MVP

On Tue, 3 Jun 2008 13:26:05 -0700, Jessica <Jes...@discussions.microsoft.com>
wrote:

Jessica

unread,
Jun 3, 2008, 7:06:01 PM6/3/08
to
Not even sure if it is protected. I am assuming whatever is wrong with the
workbook, is the same thing that is wrong with the individual sheets (4 in
total).

Jessica

unread,
Jun 3, 2008, 7:06:02 PM6/3/08
to
The workbook is not shared.

Gord Dibben

unread,
Jun 3, 2008, 7:57:11 PM6/3/08
to
I still can't tell if you are talking about a workbook or a worksheet(s) but I
will assume worksheet(s)

Do you have more than one sheet selected?

Right-click on a sheet tab.

Is "ungroup sheets" available?

If you want to send me the workbook by email, change the AT and DOT in my email
address.


Gord

On Tue, 3 Jun 2008 16:06:01 -0700, Jessica <Jes...@discussions.microsoft.com>
wrote:

Jessica

unread,
Jun 4, 2008, 7:35:02 PM6/4/08
to
It will not even let me right-click on a sheet tab. I will send the workbook.

Thanks

Cross@discussions.microsoft.com Tashina Cross

unread,
Aug 21, 2008, 10:05:01 AM8/21/08
to
I have a similar problem. I'm working with Excell 2007 and I may have
selected a feature incorrectly. I can't get the second and third worksheet
to unprotect. They are shared... but I can't seem to unshare them. HELP!

Can I email the spreadsheet to you so that you can help me?

Tashina

Gord Dibben

unread,
Aug 21, 2008, 1:43:38 PM8/21/08
to
I don't have 2007 installed.

You say worksheet 2 and 3 are shared.

You can only share an entire workbook, not a couple of sheets.

So what exactly are you trying to describe?


Gord

0 new messages