Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA questions
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA questions
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Answers to questions posing more questions in a workbook | Excel Worksheet Functions | |||
2 Questions | Excel Discussion (Misc queries) | |||
I need help with 2 Questions | Excel Discussion (Misc queries) | |||
View Questions and Answer to questions I created | Excel Discussion (Misc queries) | |||
IF questions | Excel Discussion (Misc queries) |