I can't delete my worksheets

I am using a file to maintin lists. I want to delete uneccesary worksheets,
but the "Delete Sheet" option is greyed out and unavailable, both in the
"Edit" menu and the pop-up menu. Any ideas, anyone?

Is the workbook protected?
--
HTH...

Jim Thomlinson


"chuckmcc" wrote:

> I am using a file to maintin lists. I want to delete uneccesary worksheets,
> but the "Delete Sheet" option is greyed out and unavailable, both in the
> "Edit" menu and the pop-up menu. Any ideas, anyone?

No, not yet but it will be when I distribute it.

"Jim Thomlinson" wrote:

> Is the workbook protected?
> --
> HTH...
>
> Jim Thomlinson
>
>
> "chuckmcc" wrote:
>
> > I am using a file to maintin lists. I want to delete uneccesary worksheets,
> > but the "Delete Sheet" option is greyed out and unavailable, both in the
> > "Edit" menu and the pop-up menu. Any ideas, anyone?

sorry the last reply was wrongly posted!

"Jim Thomlinson" wrote:

> Is the workbook protected?
> --
> HTH...
>
> Jim Thomlinson
>
>
> "chuckmcc" wrote:
>
> > I am using a file to maintin lists. I want to delete uneccesary worksheets,
> > but the "Delete Sheet" option is greyed out and unavailable, both in the
> > "Edit" menu and the pop-up menu. Any ideas, anyone?

No, it isn't, as far as I can tell. I looked at that first thing. It is a
shared workbook when at the office, but when I take a copy home, where it's
not in a shared directory, I still can't delete the worksheets.

"Jim Thomlinson" wrote:

> Is the workbook protected?
> --
> HTH...
>
> Jim Thomlinson
>
>
> "chuckmcc" wrote:
>
> > I am using a file to maintin lists. I want to delete uneccesary worksheets,
> > but the "Delete Sheet" option is greyed out and unavailable, both in the
> > "Edit" menu and the pop-up menu. Any ideas, anyone?

Do you see [Shared] in the title bar?

If yes, then there are lots of things that can't be done with shared
workbooks--including deleting worksheets.

chuckmcc wrote:
>
> No, it isn't, as far as I can tell. I looked at that first thing. It is a
> shared workbook when at the office, but when I take a copy home, where it's
> not in a shared directory, I still can't delete the worksheets.
>
> "Jim Thomlinson" wrote:
>
> > Is the workbook protected?
> > --
> > HTH...
> >
> > Jim Thomlinson
> >
> >
> > "chuckmcc" wrote:
> >
> > > I am using a file to maintin lists. I want to delete uneccesary worksheets,
> > > but the "Delete Sheet" option is greyed out and unavailable, both in the
> > > "Edit" menu and the pop-up menu. Any ideas, anyone?

--

Dave Peterson

Okay, yes--I thought that might be the problem. Thank you for the help. Is
there any way to "un-share" the workbook? Even when I make a stand-alone
copy in an independant directory it still calles it (Shared).


"Dave Peterson" wrote:

> Do you see [Shared] in the title bar?
>
> If yes, then there are lots of things that can't be done with shared
> workbooks--including deleting worksheets.
>
> chuckmcc wrote:
> >
> > No, it isn't, as far as I can tell. I looked at that first thing. It is a
> > shared workbook when at the office, but when I take a copy home, where it's
> > not in a shared directory, I still can't delete the worksheets.
> >
> > "Jim Thomlinson" wrote:
> >
> > > Is the workbook protected?
> > > --
> > > HTH...
> > >
> > > Jim Thomlinson
> > >
> > >
> > > "chuckmcc" wrote:
> > >
> > > > I am using a file to maintin lists. I want to delete uneccesary worksheets,
> > > > but the "Delete Sheet" option is greyed out and unavailable, both in the
> > > > "Edit" menu and the pop-up menu. Any ideas, anyone?
>
> --
>
> Dave Peterson
>

Wait--It appears I have figured how to do what I asked you about. Thank you
so much...

Chuck

"Dave Peterson" wrote:

> Do you see [Shared] in the title bar?
>
> If yes, then there are lots of things that can't be done with shared
> workbooks--including deleting worksheets.
>
> chuckmcc wrote:
> >
> > No, it isn't, as far as I can tell. I looked at that first thing. It is a
> > shared workbook when at the office, but when I take a copy home, where it's
> > not in a shared directory, I still can't delete the worksheets.
> >
> > "Jim Thomlinson" wrote:
> >
> > > Is the workbook protected?
> > > --
> > > HTH...
> > >
> > > Jim Thomlinson
> > >
> > >
> > > "chuckmcc" wrote:
> > >
> > > > I am using a file to maintin lists. I want to delete uneccesary worksheets,
> > > > but the "Delete Sheet" option is greyed out and unavailable, both in the
> > > > "Edit" menu and the pop-up menu. Any ideas, anyone?
>
> --
>
> Dave Peterson
>