ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   setting error handling on control creation and deletion (https://www.excelbanter.com/excel-programming/354029-setting-error-handling-control-creation-deletion.html)

Joe

setting error handling on control creation and deletion
 
Could you please help me on how I can set error handling and some sample code
if any:
when I create a 'menu item' and remove a 'menu item' or a control in a
worksheet,
here is the sample code that I used to remove the control:

Application.CommandBars("Worksheet Menu Bar").Controls("my control").Delete

Your help will be greatly appriciated.


All times are GMT +1. The time now is 02:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com