But if I'm just working on a workbook that has nothing to do with the
original creator anymore, i.e., they won't be working on it anymore, and I've
saved it as a copy or new doc for my own use, then it is indeed so retarded
that I wouldn't be able to delete a worksheet. Can't they put a function in
that when a copy is made, it resets the sharing functions?
"Gord Dibben" wrote:
If the workbook is shared, you will be unable to delete sheets.
And that is SO not retarded because it prevents me from deleting a sheet you may
be working on.
Have a look under ToolsShare Workbook.
Sounds to me like you are a newbie to Excel.
Would you like some URL's to a few Tutorial sites?
Gord
On Fri, 8 Sep 2006 19:59:02 -0700, le tamster
wrote:
Thanks for the insight. But even when I saved as a new document, those
options remained and I was still unable to delete worksheets. That's SO
retarded.
"Gord Dibben" wrote:
Your statement "Since you can't delete Excel worksheets unless you're the
creator of the document" is incorrect.
Worksheets can be deleted by anyone.
Exception...........
If under ToolsProtection someone has enabled Workbook Protection which will not
allow sheets to be deleted if the Structure is protected.
The workbook protection must be disabled, perhaps a password is required.
Gord Dibben MS Excel MVP
On Fri, 8 Sep 2006 15:59:01 -0700, le tamster <le
wrote:
I had a work issue where I could have fixed worksheet formatting in less than
a minute IF I was able to delete worksheets. Since you can't delete Excel
worksheets unless you're the creator of the document, it took over an hour to
complete. Why does Excel have this obnoxious feature?
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/comm...et.f unctions
Gord Dibben MS Excel MVP