Function Delcarations
 

I have comes across some code that has functions that have
not bee declared as either private or public. What does
this mean? Is this old syntax or is there a difference
bewteen this and private/public.

Thanks

Function Delcarations
 

If there is no declaration, they default to public.

Function Delcarations
 

Really? Normally you see Subs and Functions with neither declared.

If undeclared, it defaults to Public.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"ExcelMonkey" wrote in message
...
I have comes across some code that has functions that have
not bee declared as either private or public. What does
this mean? Is this old syntax or is there a difference
bewteen this and private/public.

Thanks

Function Delcarations
 

As a general rule you should explicitly declare all functions and procedures
as being either private or public. Not stating a declaration defaults to
public. The code you write should be as private as possible. This makes
debugging and modifying a lot easier because by limiting the scope you know
what can have an effect outside your current module and what can not.

HTH

"ExcelMonkey" wrote:

I have comes across some code that has functions that have
not bee declared as either private or public. What does
this mean? Is this old syntax or is there a difference
bewteen this and private/public.

Thanks