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.

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


"Jessica" wrote:

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.

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
ToolsProtection.

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
wrote:

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.

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).

"Gord Dibben" wrote:

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
ToolsProtection.

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
wrote:

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.

The workbook is not shared.

"Mike H" wrote:

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


"Jessica" wrote:

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.

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
wrote:

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).

"Gord Dibben" wrote:

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
ToolsProtection.

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
wrote:

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.

It will not even let me right-click on a sheet tab. I will send the workbook.

Thanks

"Gord Dibben" wrote:

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
wrote:

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).

"Gord Dibben" wrote:

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
ToolsProtection.

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
wrote:

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.

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" wrote:

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
ToolsProtection.

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
wrote:

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.

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

On Thu, 21 Aug 2008 07:05:01 -0700, Tashina Cross <Tashina
wrote:

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" wrote:

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
ToolsProtection.

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
wrote:

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.