At my wits end

[Paul_Hossler]

Delete those antique "Forms" style Buttons and replace them with new and improved "Control Toolbox" style Command Buttons.

Right Click each CommandButton and choose "View Code" to create new CommandButton_Click Event Subs.

Put the Original sort code into the new CommandButton_Click() Event Subs that were auto created in the Template Sheet's Code page. Note that if you use the Control's Property sub-menu to change the names before "View Code", those names will be reflected in the Event subs. The Control Name and the Sub Name must match.

"Control Toolbox" Controls are identical to the Controls used when you create a UserForm. They and their code are integral to their container, whether copied or moved.

That's what I did for the OP in the 'template tab' when I generated 'Master_v1' in post #17. The generated separate 'teacher' workbook's buttons are not linked to the source workbook

[elsone31]

Sam,

THANK YOU, so simple and works absolutely perfectly!!!! Woo hoo.