Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Enabling Disabled Features?

Status
Not open for further replies.

DaveVikingPE

Structural
Joined
Aug 9, 2001
Messages
1,008
Location
US
I was given a spreadsheet containing multiple worksheets. I would like to refine this spreadsheet by removing several of the worksheets. I'd also like to change the color of some of the worksheet tabs.

I'm not able to do either by the usual means (i.e., right-click and delete or change tab color). The spreadsheet is not protected. It's not locked, it's not read-only, there's nothing in the secret Help>About M$ Excel>Disabled Items box. Nada.

I can add worksheets to my heart's desire but once added, I can't delete 'em.

I've done some web searching and all I find are ways to change tab colors, etc. by the usual, obvious means.

Any ideas?

 
Ahhhh.... Welcome to the world of shared workbooks...

Well, that was easy: I just un-shared it. Since it's mine and mine alone.

Note for future: have the creator of the shared workbook explain how the changes will work, etc. I've not used a shared workbook before.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top