Move shape(button 1) from active sheet to next sheet

Hi experts

I have code create sheets . what I want procedure to put in the end of the code to move shape(button 1) from active sheet to next sheet after the code create new sheet added by code . I don't want copying button 1 , just move from active sheet to next sheet .

example: active sheet is STOCK and move the button 1 to the new added sheet will be STOCK_JAN and when STOCK_JAN is active and move the button 1 to the new added sheet will be STOCK_FEB and so on .
also posted here
https://www.mrexcel.com/board/thread...sheet.1255956/
by the way I got some assistance from some members but doesn't seem to work for me
as bold some lines to unerstand how work prcedure I got from the other forum.

Please Login or Register  to view this content.

Hi there,

See if the following code gets you moving in the right direction:

Please Login or Register  to view this content.

The highlighted values may be altered to suit your requirements.


Hope this helps - please let me know how you get on.

Regards,

Greg M

Hi
your code works as I want ,but

The highlighted values may be altered to suit your requirements.

you misunderstood !
instead of sheet1 will be active sheet . instead of sheet2 I can't specify sheet name because will change based on active sheet . when select specific sheet should move the button to next sheet directly (meaning will change sheet name every time).
I hope you have idea to achieve that.

Awesome !
I have question : it's possible to delete button from STOCK sheet , I don't need it ?

#4 updated.

I' m not sure what's my bad!
I changed month in PC to APR until add STOCK_APR based on current month and move button from STOCK_MAR sheet to STOCK_APR
but shows object variable or with block variable not set

Please Login or Register  to view this content.

#4 updated.

Excellent !
much appreciated for your time & help .