Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 36
Default ThisWorkbook Macros

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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 36
Default ThisWorkbook Macros

Cool. Thanks for your help.

Random.

On Sat, 16 Aug 2003 10:47:52 -0400, "Tom Ogilvy"
wrote:

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


Random <Random@nwhere wrote in message
.. .
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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I want to effect all sheets...ThisWorkbook? JSnow Excel Discussion (Misc queries) 4 December 17th 08 10:05 PM
Workbook_Open in ThisWorkbook.module Bob Barnes Excel Discussion (Misc queries) 1 February 12th 08 07:52 PM
ThisWorkbook.Print question Dave Excel Discussion (Misc queries) 1 November 19th 07 05:55 PM
Problem with ThisWorkbook.RefreshAll Vick Excel Discussion (Misc queries) 3 September 7th 07 12:26 AM
ThisWorkbook of personal.xls Jack Sons Excel Discussion (Misc queries) 4 August 29th 07 04:28 PM


All times are GMT +1. The time now is 09:56 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"