Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 44
Default Run worksheet module code from workbook module?

How can you run code that exists in a worksheet module from a command in the
workbook module?

Thanks,

Keith


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,080
Default Run worksheet module code from workbook module?

For example:

Sheet1.MyMacro

However, this is generally not advisable as worksheet and workbook macros
should be related only to event procedures, as a matter of good programming
practice.

--

Vasant


"keithb" wrote in message
...
How can you run code that exists in a worksheet module from a command in
the workbook module?

Thanks,

Keith



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
code in module A to not execute a Worksheet_SelectionChange sub of another module Jack Sons Excel Discussion (Misc queries) 4 December 11th 05 11:52 PM
VB Code Location; sheet, workbook, module James Hamilton Excel Programming 2 June 22nd 05 08:08 AM
Moved code from worksheet to module Phil Floyd Excel Programming 4 March 23rd 05 08:49 PM
Adding Code to the This_workbook module of a created workbook RPIJG[_68_] Excel Programming 1 July 9th 04 06:35 PM
Adding Code Module to Workbook Charles Excel Programming 2 January 6th 04 08:43 AM


All times are GMT +1. The time now is 08:28 PM.

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

About Us

"It's about Microsoft Excel"