1. This has to do with where the code is called from, what the code does to
what, the developer's style and sense of order, but main consideration is
where the relevant events are located. See
http://www.cpearson.com/excel/events.htm

2. It's probably most useful in a workbook event. "Automatically" means that
the sheets are renamed when exactly what happens ?
(You will find clues to this on the Events page)

HTH. best wishes Harald

"Adam" skrev i melding
...
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