Hey, need help to solve that problem:
Quote
I put all the macros of my workbook inside an add-in, which is loaded inside of Excel.
But now I additionally have Worksheet_Change codes & Workbook_Open & Workbook_Close codes, which I want to put from the workbook inside the add-in. (Reason: save workbook as .xls!)
1) How can I add those into the add-in? (all macros are inside Module1 in the add-in, I don't seem to find how to add a Sheet into VB(Microsoft Excel Objects) (it would be Sheet5 with the name "Tool"), I can only choose between Sheet1,2,3
2) I only want that those worksheet_change & workbook_open/close codes are active when a very specific file is opened. Maybe there is a function. If Filename="Exceltool23.xls" then continue, otherwise don't execute workbook_open/close/worksheet_change events from add-in
Reason: If I open another workbook there will be errors when executing workbook_open/worksheet_change things.
2000fg if you can make it work!
/ waiting for funny comments also ofc.