Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Call Private Function from ThisWorkbook module
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Call Private Function from ThisWorkbook module
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Call Private Function from ThisWorkbook module
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Call Private Function from ThisWorkbook module
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 | |
|
|
Similar Threads | ||||
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) |