Copying ActiveX Command Button from master sheet to subsheets. command button code missing

ActiveX controls don't bring the code with them. I haven't tried this with Form controls but generally Form controls are linked to a Sub and I would expect copies of the controls to be linked to the same Sub but not for Sub itself to be copied. The two use different mechanisms for events: Forms buttons are explicitly linked to a Sub but ActiveX buttons use callbacks that are supported in VBA. You can name a sub for a Forms button anything you want as long as it's a Public Sub in a standard module. The Sub for ActiveX controls must have specific names and be in the same module where the button lives.

If you make a copy of the entire worksheet, instead of copying the contents of the worksheet to other sheets, then the code will also be copied along with the buttons.

big thanks for this. Yep, basically I moved "adding the buttons" from the last thing executed in my suite of functions, to the first thing. I created a master form with the buttons in a "safe area" where they wouldn't be overwritten with pasted new data.

I created another button/macro that copies the entire master worksheet (with the active x command buttons) to a new sheet (renaming it) and then carried on with the rest of the functions in the new sheet as before. At the end, i added more code to move the buttons that are in the safe area of the new sheet into the correct position on the new sheet.

it doesn't seem the most elegant manner (looks more like a redneck hoedown) but it works and will do until I learn more about VBA, buttons etc. where it may look more like a waltz.

thanks again. you have saved me hours.

I'm glad I saved you time even if I feel like I didn't do anything :-) If you need further help you can also attach your file here for more specific diagnosis and suggestions.

If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

the answer was what was needed. once i know the individual copy couldn't be done, it was easier to think of alternatives. it prompted me to work out an initial set-up routine. thanks again and changing to "solved"