Excel 2010 - Cannot Add or Delete tabs

[Shoultes]

I need help figuring out why I cannot add or delete tabs in my workbook. The file is not shared nor is it password protected. What else could be causing me the issue that when I right click on a tab the option to delete, copy or move are grayed out.

[Paul]

Hi Shoultes,

Perhaps a macro or add-in disabled those options. To reset the worksheet tab's context (right-click) menu, put the following code into a module and run it.

Sub resetTabMenu()
Application.CommandBars("Ply").Reset
End Sub

[Shoultes]

I'm using Excel 2010 and not sure where to enter the code you supplied below. I dont see 'module' as an option when I right click on the tab.

[Paul]

Press ALT+F11 to open the VB Editor window. Click Insert > Module. Paste the code into the blank module window. Click anywhere within the code and press F5 to run the macro. Close the VB Editor.

[Shoultes]

I'm back to normal! Thanks!

[SimRyd]

Hi Paul, I have the same problem however the aforementioned solution changes nothing. Any other ideas? Also using 2010. Cannot insert or delete tabs, options greyed out. Worksheet is fully unprotected, no tracking of changes, no protection whatsoever. Help!

Thanks.

[arlu1201]

SimRyd,

Welcome to the Forum.

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.