This Workbook or Worksheets for VBA

[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

 

[Chip Pearson]

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.

 

[Mickey]

Hi Chip,
Thanks for the reply which makes sense and will be a great help.

Mickey