Accidentally deleted right click menu.

[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.

 

[Billy Liddel]

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