-----Original Message-----
Yadira
Any chance you have more than one worksheet selected? If so, you should see
the word [group] in your Title Bar.
Gord Dibben Excel MVP
I have been using a worksheet for awhile that I have to
unprotect everytime I want to update.
TOday the unprotect sheet option is greyed out and I get a
message saying the worksheet is protected.
Any ideas Office 2000
Thanks!!
.
-----Original Message-----
Yadira
Any chance you have more than one worksheet selected? If so, you should see
the word [group] in your Title Bar.
Gord Dibben Excel MVP
I have been using a worksheet for awhile that I have to
unprotect everytime I want to update.
TOday the unprotect sheet option is greyed out and I get a
message saying the worksheet is protected.
Any ideas Office 2000
Thanks!!
.
yes the word GROUP is in the title bar.
there are several worksheets in the work book.
How do I ungroup? I found the group and outline feature
but its also greyed out.
Also each worksheet is linked to several other workbooks.
-----Original Message-----
Yadira
Any chance you have more than one worksheet selected? If so, you should see
the word [group] in your Title Bar.
Gord Dibben Excel MVP
I have been using a worksheet for awhile that I have to
unprotect everytime I want to update.
TOday the unprotect sheet option is greyed out and I get a
message saying the worksheet is protected.
Any ideas Office 2000
Thanks!!
.
-----Original Message-----
To ungroup sheets, right-click on a sheet tab and "Ungroup sheets".
This type of "grouping" is not the type you see in Data>Group and Outline
which goups data on sheets.
You group sheets by selecting one then right-click and "select all sheets" or
by CRTL + Click on individual sheets or by SHIFT + Click on first sheet then
another to include those in between.
A WORD OF CAUTION.......while your sheets were grouped, any changes made to
one would have been done to all others in the group.
Perhaps you should check each sheet for accuracy. You may have had these
sheets grouped for a while.
The "linking" to other sheets and books should not pose a problem.
Gord Dibben Excel MVP
yes the word GROUP is in the title bar.
there are several worksheets in the work book.
How do I ungroup? I found the group and outline feature
but its also greyed out.
Also each worksheet is linked to several other workbooks.
If-----Original Message-----
Yadira
Any chance you have more than one worksheet selected?
so, you should seethe word [group] in your Title Bar.
Gord Dibben Excel MVPgetwrote:
I have been using a worksheet for awhile that I have to
unprotect everytime I want to update.
TOday the unprotect sheet option is greyed out and I
amessage saying the worksheet is protected.
Any ideas Office 2000
Thanks!!
.
.
Thank you so much!!
It worked. I googled it and looked in the KB but nothing
came up regarding this type of grouping.
-----Original Message-----
To ungroup sheets, right-click on a sheet tab and "Ungroup sheets".
This type of "grouping" is not the type you see in Data>Group and Outline
which goups data on sheets.
You group sheets by selecting one then right-click and "select all sheets" or
by CRTL + Click on individual sheets or by SHIFT + Click on first sheet then
another to include those in between.
A WORD OF CAUTION.......while your sheets were grouped, any changes made to
one would have been done to all others in the group.
Perhaps you should check each sheet for accuracy. You may have had these
sheets grouped for a while.
The "linking" to other sheets and books should not pose a problem.
Gord Dibben Excel MVP
yes the word GROUP is in the title bar.
there are several worksheets in the work book.
How do I ungroup? I found the group and outline feature
but its also greyed out.
Also each worksheet is linked to several other workbooks.
-----Original Message-----
Yadira
Any chance you have more than one worksheet selected? If
so, you should see
the word [group] in your Title Bar.
Gord Dibben Excel MVP
On Mon, 21 Jun 2004 12:57:09 -0700, "Yadira"
<[email protected]>
wrote:
I have been using a worksheet for awhile that I have to
unprotect everytime I want to update.
TOday the unprotect sheet option is greyed out and I get
a
message saying the worksheet is protected.
Any ideas Office 2000
Thanks!!
.
.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.