![]() If I change it on the code on the worksheet which IS working, then I get the same error. I've come to the conclussion that the button's internal name is the issue. ![]() 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. ![]() 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. "Load macro", "Enter" or whatever you like) Is it on the developer tab, on the right click menu on the button and then on Properties, or on the Excel Ribbon Ive searched for that Name Box but doesnt seem to be anywhere. When you insert a Form Control from the Developer menu in Excel, you can manually assign a name to it (i.e. Thank you for your assistance royUK, however I cant find that box you referred.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |