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
Click to expand...
 
You must log in or register to reply here.

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

Macro to add code to ThisWorkbook module 2
Remove custom menu 1
Macro to delete macro? 4
Call user form from ThisWorkbook; close file if form closed 2
The best way to build your own VBA library 2
Can I add code to ThisWorkbook module with VBA extensibility? 4
how to use modules so that values calculated in one of them can beused by another? 1
two "ThisWorkbooks" 1

Back
Top