rsilberfarb
05-19-2005, 09:46 AM
Hello All,
I have a master file that I use to generate an Excel based user form. The master document has several macros in it that do not need to be in the user form. I generate the form by saving the file as a different name, but all the macros transfer to the user form. One macro in particular is in the workbook open sub, so it runs when the workbook is open.
I need to be able to disable that one line in the workbook open sub (I have antoher line of code in there that creates a custom toolbar) .
Thanks in advance
Ross
I have a master file that I use to generate an Excel based user form. The master document has several macros in it that do not need to be in the user form. I generate the form by saving the file as a different name, but all the macros transfer to the user form. One macro in particular is in the workbook open sub, so it runs when the workbook is open.
I need to be able to disable that one line in the workbook open sub (I have antoher line of code in there that creates a custom toolbar) .
Thanks in advance
Ross