Accidentally deleted right click menu.

  • Thread starter Thread starter praavDa
  • Start date Start date
P

praavDa

Hello,

I have this little problem - when creating macro, I accidentally
deleted right click menu - that is I deleted all the positions from
the menu. Now it is deleted in all spreadsheets - I even rebooted and
it is still missing:)

The question is - can I restore it? How?

Will be glad for any help,
Mike.
 
Hi Mike

Try this macro in a general Module.

Public Sub restoreCellMenu()
Application.CommandBars("Cell").Enabled = True
End Sub

If you know which workbook disables this command you could insert the
command in a Workbook_BeforeClose or Workbook_Decactivate procedure or call
it from both these events.

Put these in the workbook module.

Private Sub Workbook_BeforeClose()
restorecellmenu
end sub

Regards
Peter Atherton
 
Back
Top