This Workbook or Worksheets for VBA

  • Thread starter Thread starter Mickey
  • Start date Start date
M

Mickey

Hi all,
I am learning some VBA to make more of Excel. In one book I am told to add
all the macros to 'This Workbook' whilst another book has me creating code
in separate worksheets as well as 'This Workbook'

Is there a proper way to do this as I would like to follow the correct path
to having the code run properly.

Thanks,
Mickey
 
Mickey,

Generally speaking, the ThisWorkbook module should contain only event
procedures for the workbook, and perhaps private procedures in support of
those event procedures. Similarly, the Sheet modules should contain only
event procedures for that particular sheet. If you don't know what an event
procedure is, then don't worry about it and don't put any code at all in
these modules. All other code should go in standard code modules, those you
insert from the Insert menu in VBA.
 
Back
Top