(April 19, 2016 at 11:40 pm)Cthulhu Dreaming Wrote:(April 19, 2016 at 11:16 pm)Goosebump Wrote: Is this all internal, intranet stuff? Cause I wouldn't use any of this in web.
TBH, I wouldn't use any of this stuff for anything anyone else is going to have to support. The IT guys will eat your children.
Macros are best used in my opinion for personal task automation, not company wide installation. I created a few macro worksheets to automate reports for my old department and save as read only files so they can be used each week as needed and still run a year later since I changed positions. However, yes, IT will not want to dive into development mode and try to dissect VBA code if something breaks.
Most of the stuff I create now is for my department to use, and always saved as read only, so no one can go in and screw something up for the next person.