Public is not Public
Since sheet modules are a class module you need to qualify the sub name.
For instance, if your public sub in Sheet1 is "test", then in the Sheet2
code module, use
Call Sheet1.test
Note that you should use the sheet's code name as the qualifier.
In article ,
clara wrote:
Why a public sub (defined in a sheet module ) can not be called in code
behind another sheet ?
|