I've been attempting to convert some of my macros into excel add-ins, but because some of them need to run on the ThisWorkbook module they don't transfer over. Is there a way to make like an ActiveWorkbook module for doing this?
I've been attempting to convert some of my macros into excel add-ins, but because some of them need to run on the ThisWorkbook module they don't transfer over. Is there a way to make like an ActiveWorkbook module for doing this?
The code must go in the Thisworkbook class module, but you need to consider how you refer to worksheets in the Addin. Have a read about the THISWORKBOOK and the ACTIVEWORKBOOK objects.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks