Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
Is it possible to call a Private Function, which resides in a normal module, from the ThisWorkbook module? If it can be done, How? Regards, -- Beto Reply: Erase between the dot (inclusive) and the @. Responder: Borra la frase obvia y el punto previo. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Beto,
No, if it's private it means that it doesn't want to be accessible from another module. It needs to be Public for that. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Beto" wrote in message ... Hi, Is it possible to call a Private Function, which resides in a normal module, from the ThisWorkbook module? If it can be done, How? Regards, -- Beto Reply: Erase between the dot (inclusive) and the @. Responder: Borra la frase obvia y el punto previo. |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Bob Phillips wrote:
Beto, No, if it's private it means that it doesn't want to be accessible from another module. It needs to be Public for that. Just what I thought. I was hoping there may be a way to reference the module and then the function, sort of like "Module1.Function1". Anyway, I already solved my problem with a workaround. Regards, -- Beto Reply: Erase between the dot (inclusive) and the @. Responder: Borra la frase obvia y el punto previo. |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The way you describe is how you reference a Public function in a class
module, like ThisWorkbok, from another module. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Beto" wrote in message ... Bob Phillips wrote: Beto, No, if it's private it means that it doesn't want to be accessible from another module. It needs to be Public for that. Just what I thought. I was hoping there may be a way to reference the module and then the function, sort of like "Module1.Function1". Anyway, I already solved my problem with a workaround. Regards, -- Beto Reply: Erase between the dot (inclusive) and the @. Responder: Borra la frase obvia y el punto previo. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
compile error in hidden module: thisworkbook | Excel Discussion (Misc queries) | |||
Private Sub - Only Accessible from same Module? | Excel Discussion (Misc queries) | |||
Workbook_Open in ThisWorkbook.module | Excel Discussion (Misc queries) | |||
Compile error in hidden module: ThisWorkbook | Excel Discussion (Misc queries) | |||
Compile error in hidden module: ThisWorkbook | Excel Discussion (Misc queries) |