View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
blanch2009 blanch2009 is offline
external usenet poster
 
Posts: 4
Default Sheet Tabs & Right Clicking

All of a sudden I have no right click on my sheet tabs. The sheet or even
the workbook is not protected in any way.
Normally you can right click on a sheet tab and either delete, rename, copy,
ect.
Now nothing. The tab is not grayed out and if you double click it you can
rename but that's it.
Does anyone know how to fix this problem?

I used the Application.CommandBars("Ply").Enabled = True command in VB and
it works to bring my right click back but as soon as I exit Excel and reopen
the problem comes back.

Thanks In Advance