J
Jimmy
The command to "Delete Sheet" in the "Edit" menu is greyed out
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave R.
Is anything else in the edit menu grayed out?
B
Bob Phillips
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)
Excel help.
--
HTH
RP
(remove nothere from the email address if mailing direct)
J
John Mansfield
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.
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.
J
Jimmy
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
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
J
Jimmy
Tried that Bob but thanks anyway
Bob Phillips said: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)
J
Jimmy
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
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
B
Bill Sharpe
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
The command to "Delete Sheet" in the "Edit" menu is greyed out
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
The command to "Delete Sheet" in the "Edit" menu is greyed out
B
Bill Sharpe
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
The command to "Delete Sheet" in the "Edit" menu is greyed out
own estimate here) of the program's power.
For a more varied response look at what the other posters have to say.
Bill
The command to "Delete Sheet" in the "Edit" menu is greyed out
J
JulieD
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
you said you checked for the "worksheet" being protected - but did you check
for the WORKBOOK being protected - tools / protection / protect workbook
Cheers
JulieD
J
Jimmy
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
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