Larry,

While there is no performance impact of the location of the code,
where you put it is important. In general, you should put all
your macros and functions in standard code modules. The only
thing that should be in the ThisWorkbook and the Sheet modules
are the event procedures for those objects.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"nrage21 " wrote in
message ...
is there a difference between writing VBA code in...
1) This Workbook
2) Sheet
3) Module

Does any affect excel performance????

-Larry-
VBA Amateur


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