I worked really hard though this forum to get a macro to work in my spreadsheet the way I needed it to. And it does. Wonderfully.
Only problem now:
I have this macro and I want to put it in a spreadsheet that is accessable to the rest of the staff in a general folder in our intranet. Unfortunately, I'm finding that I have to manually format every computer under every user to allow macros. It's made it one heck of a headache.
Is there anyway to make the macro safer so other computers will just accept it? Or do I have to make a formula (not a macro) to do the same function that everyone else can use as well? I want to spread the joy and ease of this macro in the spreadsheet.. please help!