If I change it on the code on the worksheet which IS working, then I get the same error. It should be listed in the 'Main Tabs' group but it's not available in any group. Just check the Developer tab and click ok to add a developer tab. There it will show a menu having the list of all different tabs. Once you right click on the ribbon then click on customize the ribbon. We would study some of them in order to enable developer tab. I've come to the conclussion that the button's internal name is the issue. I have Microsoft Office Professional Plus 2013 where I can enable Developer tab on MS Word and Excel but the tab is missing in the Customize Ribbons option of MS Access as shown in the figure below. In Excel 2010 and Excel 2013, there are many options you could enable developer tab. I have another worksheet in which the vba code is actually working, but can't figure out why. I've tried different things, like changing that code to a different workbook, changing the vba code from the worksheet to a module, etc.

I'm getting an error which tells 'The parameter is not correct' and other similar errors. I'm working on a bilingual project and when the macro runs, it will change several text parts on the worksheet, and it should also change the macro button's name, and that's what is not working. What I want to do is to find out its name, so I can change it whenever I want. The design mode tab is useful only with excel containing macros. However, there seems to be an internal name for that object you've just inserted, which isn't visible but can be referred to from the vba code you use in your own macro. The Design Mode is a tool available in Developer tab that helps to toggle to design mode. 'Load macro', 'Enter' or whatever you like) When you insert a Form Control from the Developer menu in Excel, you can manually assign a name to it (i.e.

Developer tab excel 2013