How do I delete an empty worksheet.

The command to "Delete Sheet" in the "Edit" menu is greyed out

Is anything else in the edit menu grayed out?



"Jimmy" <Jimmy@discussions.microsoft.com> wrote in message
news:7D3FC389-DE06-48B1-81C9-9E7F1E81086D@microsoft.com...
> The command to "Delete Sheet" in the "Edit" menu is greyed out

Is it a shared workbook? Take a look at 'Limitations of shared workbooks' in
Excel help.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jimmy" <Jimmy@discussions.microsoft.com> wrote in message
news:7D3FC389-DE06-48B1-81C9-9E7F1E81086D@microsoft.com...
> The command to "Delete Sheet" in the "Edit" menu is greyed out

Jimmy,

Also check to see if the workbook has been protected. You can look up
protection in Excel's on-line help for a good explanation.

----
Regards,
John Mansfield
http://www.pdbook.com

"Jimmy" wrote:

> The command to "Delete Sheet" in the "Edit" menu is greyed out

No it is the only item greyed out. I have checked for the worksheet being
protected which it isnt and finally renamed the file, coopy at vast expense
of my time all the relevant details and then saved my new file under the
original name.

On reflection, this only seems to come about in files which were in use
before I got 2003. One of the Access files repeatedly tells me to check and
make sure the file is safe before loading/using

"Dave R." wrote:

> Is anything else in the edit menu grayed out?
>
>
>
> "Jimmy" <Jimmy@discussions.microsoft.com> wrote in message
> news:7D3FC389-DE06-48B1-81C9-9E7F1E81086D@microsoft.com...
> > The command to "Delete Sheet" in the "Edit" menu is greyed out
>
>
>

Tried that Bob but thanks anyway

"Bob Phillips" wrote:

> Is it a shared workbook? Take a look at 'Limitations of shared workbooks' in
> Excel help.
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "Jimmy" <Jimmy@discussions.microsoft.com> wrote in message
> news:7D3FC389-DE06-48B1-81C9-9E7F1E81086D@microsoft.com...
> > The command to "Delete Sheet" in the "Edit" menu is greyed out
>
>
>

Thanks John
I did try that but it may be that this is an echo from the previous version
of Office (2000?) but it doesn't really help

"John Mansfield" wrote:

> Jimmy,
>
> Also check to see if the workbook has been protected. You can look up
> protection in Excel's on-line help for a good explanation.
>
> ----
> Regards,
> John Mansfield
> http://www.pdbook.com
>
> "Jimmy" wrote:
>
> > The command to "Delete Sheet" in the "Edit" menu is greyed out

You don't say how many sheets there are in your workbook. One workaround
may be to copy all the sheets you want to keep to another workbook, then
erase the offending workbook. Or is this a global problem, affecting all
your workbooks?

Another approach is to just ignore the empty worksheet. Most of my
workbooks only have entries on Sheet 1, but I never bother to delete the
empty default sheets 2 and 3.

When someone gives you a lemon, make lemonade.

Bill

"Jimmy" <Jimmy@discussions.microsoft.com> wrote in message
news:7D3FC389-DE06-48B1-81C9-9E7F1E81086D@microsoft.com...
The command to "Delete Sheet" in the "Edit" menu is greyed out

If you don't use Excel functions you miss out on about 95% (insert your
own estimate here) of the program's power.

For a more varied response look at what the other posters have to say.

Bill

"Jimmy" <Jimmy@discussions.microsoft.com> wrote in message
news:7D3FC389-DE06-48B1-81C9-9E7F1E81086D@microsoft.com...
The command to "Delete Sheet" in the "Edit" menu is greyed out

hi Jimmy

you said you checked for the "worksheet" being protected - but did you check
for the WORKBOOK being protected - tools / protection / protect workbook

Cheers
JulieD

"Jimmy" <Jimmy@discussions.microsoft.com> wrote in message
news:638784E6-C768-4E2A-870C-5936B8B6F4AE@microsoft.com...
> No it is the only item greyed out. I have checked for the worksheet being
> protected which it isnt and finally renamed the file, coopy at vast
> expense
> of my time all the relevant details and then saved my new file under the
> original name.
>
> On reflection, this only seems to come about in files which were in use
> before I got 2003. One of the Access files repeatedly tells me to check
> and
> make sure the file is safe before loading/using
>
> "Dave R." wrote:
>
>> Is anything else in the edit menu grayed out?
>>
>>
>>
>> "Jimmy" <Jimmy@discussions.microsoft.com> wrote in message
>> news:7D3FC389-DE06-48B1-81C9-9E7F1E81086D@microsoft.com...
>> > The command to "Delete Sheet" in the "Edit" menu is greyed out
>>
>>
>>

Yes Bill,

There were only three sheets and I have just copied them to another new
workbook
which solved the problem but not the use of my time. Ha Ha. The offending
extra worksheet - sheet 4 - was an insult to my limited intelligence and I
looked for a way to remove it. Thanbks anyway

I have read elsewhere that files created using Excel 2000 might not be as
responsive under 2003 version

"Bill Sharpe" wrote:

> You don't say how many sheets there are in your workbook. One workaround
> may be to copy all the sheets you want to keep to another workbook, then
> erase the offending workbook. Or is this a global problem, affecting all
> your workbooks?
>
> Another approach is to just ignore the empty worksheet. Most of my
> workbooks only have entries on Sheet 1, but I never bother to delete the
> empty default sheets 2 and 3.
>
> When someone gives you a lemon, make lemonade.
>
> Bill
>
> "Jimmy" <Jimmy@discussions.microsoft.com> wrote in message
> news:7D3FC389-DE06-48B1-81C9-9E7F1E81086D@microsoft.com...
> The command to "Delete Sheet" in the "Edit" menu is greyed out
>
>
>