1. Could somebody explain what the difference is between adding code to
modules, this workbook or specific sheets.

2. I need to enter a code that automatically renames the sheet according to
the content of a specific cell. This applies to all the sheets. Should I then
enter the code for each sheet or can I simply add it to the workbook (The
same cell (B3) is used for every sheet

Thanks