| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA to delete worksheets | Excel Discussion (Misc queries) | |||
| Delete All Worksheets Apart From Some With Particular Name | Excel Discussion (Misc queries) | |||
| I can't delete my worksheets | Excel Discussion (Misc queries) | |||
| Macro to delete worksheets | Excel Programming | |||
| Delete worksheets | Excel Programming | |||
Hybrid Mode
