{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 甜甜的少女心 的问题《Excel CommandButton names changing》','https://www.manongdao.com/q-1117167.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
I created an excel file with macros on ActiveX-CommandButtons. They worked well, when I just finished them. As soon as I opened the file again, the CommandButton-Names changed.
As example:
CommandButton1 changed to CommandButton2
CommandButton2 changed to CommandButton3 etc.
I didn't found anything in my reasearch, so is this an excel bug or just something that you can change in your preferences?
Right click on CommandButton
Go to (click on) 'Format Text Effects'
Give the name to button, whichever you want.
Save it.
Close the workbook.
Open it back and check whether name changes
(No need to enable 'Design Mode')
It works for me. Hope it shall work for you too.
If it do not work then please let me know.
For more info: https://support.office.microsoft.com/en-in/article/Add-a-button-and-assign-a-macro-to-it-in-a-worksheet-d58edd7d-cb04-4964-bead-9c72c843a283?CorrelationId=345214f6-6d01-4b07-994b-b2e33159e694&ui=en-US&rs=en-IN&ad=IN