![]() |
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? |
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? |
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? |
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? |
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? |
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 |
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 |
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