ThisWorkbook Macros

  • Thread starter Thread starter Random
  • Start date Start date
R

Random

Not a real important question, since I am just playing around, but is
it possible to call functions stored in the thisworkbook module from
one of the worksheet modules? If so, what is the syntax?

Thanks,

Random
 
Cool. Thanks for your help.

Random.

go into the workbook module and change your function from Private to public.
then go to Excel into Tools=>Macro=>Macros and you will see the syntax.

Regards,
Tom Ogilvy
 
Back
Top