Disabling and Enabling Specific Menu Items via VBA

[actjfc]

Excel Friends,

I got this code to disable/enable Right Click on the Sheet Tab:

Private Sub Workbook_Activate()
   Application.CommandBars("Ply").Enabled = False
End Sub
 
Private Sub Workbook_Deactivate()
    Application.CommandBars("Ply").Enabled = True
End Sub

It worked fine, but I got out of excel totally, and it is still Disabled in all my workbooks. Enabling it is driving me crazy!

I also need hot to disable and enable Delete Sheet and Hide/Unhide sheets, in the menu, not just the Right Click.

Can somebody help!

Thanks!

 

[mole999]

if you created a copy of

Private Sub Workbook_Deactivate()
    Application.CommandBars("Ply").Enabled = True
End Sub

to

Sub test()
    Application.CommandBars("Ply").Enabled = True
End Sub

and run as normal

 

[actjfc]

It was easy! thanks! But why is not working the Sub Workbook_Deactivate?

Can somebody help me with the disabling and enabling Delete Sheet and Hide/Unhide sheets, in the menu? not just the Right Click.

Thanks!

 

[mole999]

would think workbook_close, would be better, deactivate might work in switching around.

not sure about your other problems, it will be on the web somewhere

If you do get answers, post them back to the thread for others

 

[actjfc]

Yes, I will make a new post! Thanks!

 

[Hans Troost]

Yes, I will make a new post! Thanks!

Did you do that? I'm really interested, because I need similar functionality

 

[Joe4]

Did you do that? I'm really interested, because I need similar functionality

It looks like they did, but got no response: Disabling and Enabling Delete Sheet and Unhide Sheet via VBA

If you have a question, it would be probably be better to start up a new thread so it appears on the "Unanswered threads" listing.

 

[Hans Troost]

It looks like they did, but got no response: Disabling and Enabling Delete Sheet and Unhide Sheet via VBA

If you have a question, it would be probably be better to start up a new thread so it appears on the "Unanswered threads" listing.

Thanks for figuring out. I will think about starting a thread… It is not that urgent.