Fire Macro w/WB change

[RonRepp]

Hi, All:

Thanks to a great answer in thread707-1638014, I now have a working script.

My next step is to have this menu reset and rewrite every time a workbook changes activation.

Can it be done using only an XLT WB file?

Thanks,

Ron Repp

If gray hair is a sign of wisdom, then I'm a genius.

My newest novel: Wooden Warriors

http://www.repproductions.net

 

[SkipVought]

In the Workbook Object...

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)

End Sub

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[RonRepp]

Hm, I have not changed it to a template yet, but it doesn't fire except on the first WB.

Ron Repp

If gray hair is a sign of wisdom, then I'm a genius.

My newest novel: Wooden Warriors

http://www.repproductions.net

 

[SkipVought]

Your requirement was not very clear.

Did my post suggest ANYTHING to you?

Private Sub Workbook_Activate()

End Sub

in the WORKBOOK OBJECT.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}