Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Macros to (??) .dll
Name: 24HG_Hoop Date: May 16, 2008 at 23:57:50 Pacific OS: XP Pro CPU/Ram: 2800 / 2G Product: clone
Comment:
I've got a load of Word and Excel macros [2003] written that I'm about to 'deploy' onto other client boxes here at work. Instead of fritzing with everybody's normal templates. I briefly read something a few weeks ago about making macros into something similar to an "add-in", so I could jam that onto the server and just have people install the add-in [and remove it, if they didn't want it... OR just hide that toolbar, for whatever reaason].
Is that something you can just do in VB, like a "save as" type thing?
Summary: I am trying to create a macro in an excel workbook that notifies when changes have been made to a sheet. I would like it to notify by email prior to the workbook being saved/closed. The code I have ri...