Logo 
Search:

MS Office Answers

 Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Molly Torres   on Oct 25 In MS Office Category.

Prevent user from delete a worksheet in using the shortcut menu of


  
Question Answered By: Sonya Flores   on Oct 25

I wrote the following codes
Private Sub Workbook_Close()
Application.CommandBars("ply").Enabled = True
End Sub
These code  should restore the worksheet  tab menu  when I close the workbook  and
the sheet tab should be present when I open a new workbook.

It still does not do it.

How do I restore the defaults settings in Excel?

Share: 

 

This Question has 2 more answer(s). View Complete Question Thread

 


Tagged: