I have a workbook with one worksheet in it that I use as a template to create a new sheet for each of my sales managers. In ThisWorkbook (in my template) I have some coding. It's on the workbook level and does a few various things such as; depending on which cell they have selected, Range("A1") will say various things. All of this coding in ThisWorkbook is saved in my template book... I want it to be in each workbook created for each sales manager.
Here is a snippet of my code:
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)

Select Case Target.Row
Case Is = 3
Range("B20").Formula = "=if(B3="""","""",1-(B23/B3))"

I'm not even sure if this is possible, or if there is an easier way to do what I'm wanting... TIA
DejaVu