Adding Code to the This_workbook module of a created workbook
 

I create a new workbook using the Sheets.Copy thing to send a particula
sheet of a template via email. I'd like to enter code into th
Workbook_Open procedure of that workbook that will set th
application.screenupdating to false. Is there a way to do this fro
the original template

--
Message posted from http://www.ExcelForum.com

Adding Code to the This_workbook module of a created workbook
 

Hi
see: http://www.cpearson.com/excel/vbe.htm

for adding code programmatically


--
Regards
Frank Kabel
Frankfurt, Germany


I create a new workbook using the Sheets.Copy thing to send a
particular sheet of a template via email. I'd like to enter code
into the Workbook_Open procedure of that workbook that will set the
application.screenupdating to false. Is there a way to do this from
the original template?


---
Message posted from http://www.ExcelForum.com/