Public is not Public

[Guest]

Hi all,

Why a public sub (defined in a sheet module ) can not be called in code
behind another sheet ?

Clara

 

[Norman Jones]

--

 

[Norman Jones]

Hi Clara

A public procedure should be placed in a standard module,
not a sheet module. Try, therefore, moving the code to a
standard module and your problem should be resolved.

In general, a sheet mpodule should only be used for sheet
event code,

 

[Norman Jones]

Hi Clara,

For additional information on the use of code modules,
see Chip Pearson at:

Code Module And Code Names
http://www.cpearson.com/excel/codemods.htm

 

[JE McGimpsey]

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.