Results 1 to 1 of 1
2002-01-03, 18:20 #1
- Join Date
- Dec 2000
- NJ, USA
- Thanked 1 Time in 1 Post
Calling a Private subroutine (XL2K, SR-1)
Suppose a wkb has 2 modules, Module1 and Module2, say. If Module2 has a subroutine declared as Private, is it possible to call it from within Module1? I tried qualifying the name:
, but that didn't work - although it did adjust the capitalization.
I'd prefer not having everything all in one module, but I also would like the subroutines not to be visible to the users. I believe it could be done by declaring the "cross-called" subroutines as Public, but defining them as having a bogus parameter(?). I think that stops them from being listed under Tools | Macro | Macros. Was wondering, though, if they can be explicitly called?