nightcrawler23
Well-known Member
- Joined
- Sep 24, 2009
- Messages
- 721
Hi all,
I have created a workbook with userform, custom functions and workbook events. Now i want to make this an addin. Is it possible. Can someone suggest good tutorial sites for this. What i have found are very basic and dont clear my doubts.
Currently the problems i am having is below.
1. my workbook when opened populates a listbox using the acrivesheet's name.
when converted to xl addin this gives an error bcoz the addin is loaded before the workbook is open and therefore there are no active sheets.
2.after makin this an addin will my events (workbook_open, workbook_sheetactivate etc.) work the same way as it worked for my workbook. (I guess not as my events are for the .xla file and not for the .xls file)
there may be other problems that i havent encountered yet(bcoz i couldnt get the addin to work bcoz of the first problem
). Please help.
Thanks a lot in advance. This will be a great help.
I have created a workbook with userform, custom functions and workbook events. Now i want to make this an addin. Is it possible. Can someone suggest good tutorial sites for this. What i have found are very basic and dont clear my doubts.
Currently the problems i am having is below.
1. my workbook when opened populates a listbox using the acrivesheet's name.
when converted to xl addin this gives an error bcoz the addin is loaded before the workbook is open and therefore there are no active sheets.
2.after makin this an addin will my events (workbook_open, workbook_sheetactivate etc.) work the same way as it worked for my workbook. (I guess not as my events are for the .xla file and not for the .xls file)
there may be other problems that i havent encountered yet(bcoz i couldnt get the addin to work bcoz of the first problem
). Please help.Thanks a lot in advance. This will be a great help.
