Urgently required.

Many thanks if you can assist.

If the worksheet is protected, or if the file is shared, you won't be
able to use that command.

kirkm wrote:
Urgently required.

Many thanks if you can assist.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

On Sun, 06 Aug 2006 10:05:03 -0400, Debra Dalgleish
wrote:

If the worksheet is protected, or if the file is shared, you won't be
able to use that command.

I must admit to being very ****ed off with this. Weeks of work are
wasted because this STOOPID bloody thing suddenly occured for no
reason - and ALL my backups now give the same result.

AFAIK the xls file is neither protected or shared.

I suppose I can start the whole thing again. But what if it happens
again?

Is there NO WAY to un-gray this option ? Bugger Bill Gates is all I
can say !

Thanks - Kirk

AFAIK the xls file is neither protected or shared.

"AFAIK" - a bit vague, should be able to report 100% certain.

Eliminate your toolbar file as the culprit. With no running Excel instance
rename your *.xlb to say *.bak. Restart Excel and a new default toolbar file
will be created. If that makes no difference close Excel, delete the newly
created toolbar file (ie the new *.xlb) and restore your backup.

Regards,
Peter T

"kirkm" wrote in message
...
On Sun, 06 Aug 2006 10:05:03 -0400, Debra Dalgleish
wrote:

If the worksheet is protected, or if the file is shared, you won't be
able to use that command.

I must admit to being very ****ed off with this. Weeks of work are
wasted because this STOOPID bloody thing suddenly occured for no
reason - and ALL my backups now give the same result.

AFAIK the xls file is neither protected or shared.

I suppose I can start the whole thing again. But what if it happens
again?

Is there NO WAY to un-gray this option ? Bugger Bill Gates is all I
can say !

Thanks - Kirk

On Sun, 6 Aug 2006 22:01:30 +0100, "Peter T" <peter_t@discussions
wrote:

Hello Peter,

AFAIK the xls file is neither protected or shared.

"AFAIK" - a bit vague, should be able to report 100% certain.

You're right - but I haven't enough knowledge of Excel to be certain.

Eliminate your toolbar file as the culprit. With no running Excel instance
rename your *.xlb to say *.bak. Restart Excel and a new default toolbar file
will be created. If that makes no difference close Excel, delete the newly
created toolbar file (ie the new *.xlb) and restore your backup.

I don't have any files aywhere on the computer with an 'xlb'
extension.

Have you anything else I can try?

Thanks - Kirk

Hi Kirk,

I don't have any files aywhere on the computer with an 'xlb'
extension.


Try extending your search for the recalcitant xlb file to encampass hidden
files.


---
Regards,
Norman

Is the option grey if you open a new workbook, or go to a different
sheet in the current workbook?

kirkm wrote:
On Sun, 06 Aug 2006 10:05:03 -0400, Debra Dalgleish
wrote:


If the worksheet is protected, or if the file is shared, you won't be
able to use that command.


I must admit to being very ****ed off with this. Weeks of work are
wasted because this STOOPID bloody thing suddenly occured for no
reason - and ALL my backups now give the same result.

AFAIK the xls file is neither protected or shared.

I suppose I can start the whole thing again. But what if it happens
again?

Is there NO WAY to un-gray this option ? Bugger Bill Gates is all I
can say !

Thanks - Kirk



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Would assume the worksheet is protected.

ToolsProtectionUnprotect Sheet

OR........

The workbook is shared under ToolsShare Workbook.

Unshare it.


Gord Dibben MS Excel MVP

On Mon, 07 Aug 2006 01:43:13 +1200, kirkm
wrote:


Urgently required.

Many thanks if you can assist.

On Sun, 06 Aug 2006 09:36:47 -0700, Gord Dibben <gorddibbATshawDOTca
wrote:

Hello

Would assume the worksheet is protected.

ToolsProtectionUnprotect Sheet


Under ToolsProtection there's four options

Protect Sheet
Allow Users To Edit Ranges
Protect Workbook
Protect And Share Workbook

Should I plough deeper? I see no 'Unprotect Sheet' heading.

Under 'Protect Sheet' There is a tick in 'Protect worksheet and
contents of locked cells'
If I untick that, I lose the OK button.


OR........

The workbook is shared under ToolsShare Workbook.

Unshare it.

This has no tick besides 'Allow changes by more than one user at the
same time.
This also allows workbook merging.'

Only one name (mine) is in the 'Who has....' list
The advanced menu has all options greyed out.

Thanks for anything further.
Cheers - Kirk

May I thank everyone for there help and suggestions with this problem.

It was not a problem with Excel, but with me. Normally I'd be
importing data at the end of the existing cells. My cursor was
sitting in an existing one and hence the grayed-out option.

Maybe Excel help could have helped more in this case, but
I couldn't find anything.

Many thanks to all,
Cheers - Kirk