ThisWorkbook Macros

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
 
R

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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2010 record macro default save to thisworkbook 0
Remove custom menu 1
Change_Event not responding to change made by formula. 11
how to use modules so that values calculated in one of them can beused by another? 1
How to call module function or sub from the Add In? 3
How to force macros refer to ActiveWorkbook 2
The best way to build your own VBA library 2
Copying a UDF from an Add-In module to a workbook. 3

Top