I have an excel workbook that uses active -x controls. It allows the user to model the performance of a micro-scale wind turbine (small device that fits onto a rooftop). I have VBA code that is located for each worksheet, some that is contained in Forms and other code that is located in modules.
My question is: in terms of keeping the workbook small and running quickly is it Ok to have code for each worksheet or place it in modules?
thanks, luke
Bookmarks