Worksheet vs. General modules

[Corey R.]

Hi!

What is the difference between Worksheet and General?

Why does my code need to be in Worksheet in order to work?

I cannot seem to add more than one "Sub" to a worksheet, it automatically sends it to General.

Thanks.

[VBA Noob]

For info on the different types of Worksheet events type the below in help

Worksheet Object Events

You can only use one type e.g only one

Worksheet_Change

event for example.

Sub modules should really go in it's own module. You can add a module under the menu Insert module

You can only place code in ThisWorkbook

VBA Noob

[Andy Pope]

Why does my code need to be in Worksheet in order to work?

Very hard to tell without seeing your code. But here are a few reasons;
- referencing something that is local to the worksheet, such as a control
- using the ME reference object
- using event code