ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   I can't delete my worksheets (https://www.excelbanter.com/excel-programming/356358-i-cant-delete-my-worksheets.html)

chuckmcc

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?

Jim Thomlinson

I can't delete my worksheets
 
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?


pywhacket

I can't delete my worksheets
 
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?


pywhacket

I can't delete my worksheets
 
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?


chuckmcc

I can't delete my worksheets
 
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

I can't delete my worksheets
 
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

chuckmcc

I can't delete my worksheets
 
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


chuckmcc

I can't delete my worksheets
 
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



All times are GMT +1. The time now is 06:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com