Originally Posted by
Jakobshavn
Post your code or share your workbook.
Sorry, but I don't know how to share a workbook on this forum or how to post the entire image of code window (other than including a screen
capture image)
Here is the code that processes the SelectionChange event (the top of the VME window shows "Sheet2(Code)" (Sheet2 is the template sheet)
if I set a breakpoint in this code, when I click on a cell in the copied sheet, the selected sheet changes to Sheet2 but this code does not
execute until I select a cell in Sheet2.
===========================================
======================================
Evidently, this code is only associated with the template sheet and does not get associated with the copy of the template sheet that I create
for each student. Somehow selecting a cell in the copied sheet causes the template sheet to be activated. Here is the code that I use to create
the new student work sheets: (sheet "StuMaster" contains the student name list; each student record is tagged with the label "student" in column 2:
======================================
==============================================
Bookmarks