N
NiNi
I am using VBA to add menu when the workbook is opened. Delete a bar if it
exists already and add one later, if not, add one. But seems the on error
resume next doesn't work. If it doesn't exist, it stopped and popup error
message. Anyone has experience? Thanks a lot.
On Error Resume Next
Application.CommandBars("worksheet Menu Bar").Controls("&Deal
Summary").Delete
On Error GoTo 0
exists already and add one later, if not, add one. But seems the on error
resume next doesn't work. If it doesn't exist, it stopped and popup error
message. Anyone has experience? Thanks a lot.
On Error Resume Next
Application.CommandBars("worksheet Menu Bar").Controls("&Deal
Summary").Delete
On Error GoTo 0