Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Reference Addin Module from sheet code | Excel Programming | |||
Remove Excel AddIn from AddIn List !! Help | Excel Programming | |||
Accessing Addin from Sheet_Event Code | Excel Programming | |||
Accessing Addin from Sheet_Event Code | Excel Programming | |||
using a function in an addin in my vba code | Excel Programming |