Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations cowski 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
Aug 9, 2001
1,008
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?

 
Replies continue below

Recommended for you

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