LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default using code from an addin

okay, this should be pretty darned simple, but it seems those are always the things that jump up and bite me

i've created a workbook that has 12 modules and 7 user forms. this workbook will be distrubuted to others, so obvioulsy the best thing to do is to make all the code an add in and have some basic workbook and worksheet functions that call the add in code.
i've gotten that far, and added code that successfully adds the add in at the opening of the workbook. but then it says that it can not see any of my add in module names.
am i referencing them incorrectly? this has to be something that is very simple that i am just having a brain hiccup on....

i.e.

Private Sub Worksheet_Change(ByVal Target As Range

AddInWorksheet_Change Targe

End Su

where AddInWorksheet_Change is defined in the addin workbook as a public sub

Public Sub AddInWorksheet_Change(ByVal Target As Range

Dim sCellAddress As Strin
Dim rNew As Rang
Dim rOld As Rang
etc.....

thanks much
heidi
 
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
Reference Addin Module from sheet code zSplash Excel Programming 2 April 19th 04 06:35 PM
Remove Excel AddIn from AddIn List !! Help carl Excel Programming 2 December 8th 03 03:36 PM
Accessing Addin from Sheet_Event Code zSplash Excel Programming 3 December 7th 03 09:52 PM
Accessing Addin from Sheet_Event Code zSplash Excel Programming 0 December 7th 03 05:35 PM
using a function in an addin in my vba code archangel Excel Programming 2 September 6th 03 08:09 AM


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