MACRO Query relating to VBA codes to put up into modules

You can use the sheet1/thisworkbook objects to store macros that are triggered by events. For example, if you wanted to Select the first sheet whenever a workbook is opened you could put:

Please Login or Register  to view this content.

in the thisworkbook object, or to select A1 whenever a sheet1 is activated you could put

Please Login or Register  to view this content.

In the sheet1 object.

If you just have general macros which do not rely on a particular event or sheet/workbook object it is usually best to place them in a standard module (insert->module). This will appear in a seperate folder titled "module" underneath the sheet/workbook objects in the project folder view.