LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,514
Default How to change add-in object from within worksheet module.

Hi all,
I have an add-in with some modules and a few forms in it.
Also I have the worksheet with the module, which has the reference to
this add-in. How can I reach form objects located in add-in from
worksheet module code? Looks like the object in add-in are not
visible from this place. Thanks in advance for help.

Regards
Archidamos


One way is to have your addin create menus at startup so you can access
its functionality at any time. Note that it's necessary to delete any
custom menus at shutdown so as not to modify Excel's TLB file.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


 
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
Worksheet_Calculate code in same module as Worksheet Change eventgoes astray Harold Good Excel Programming 4 December 18th 09 06:59 PM
Run procedure in stored in module on worksheet change event Daniel Jones Excel Programming 5 August 8th 09 10:11 PM
Pass worksheet object name to a class module [email protected] Excel Programming 1 May 9th 07 12:48 PM
Range object and worksheet change event Paulymon Excel Programming 3 September 26th 06 08:06 AM
Run worksheet module code from workbook module? keithb Excel Programming 1 August 14th 05 04:04 AM


All times are GMT +1. The time now is 01:17 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"