I've googled and searched and tried everything I can think of but I'm no closer to solving this problem, so if anyone has read through this wall of text and can come up with a possible solution, that would be greatly appreciated to save me from tearing ALL my hair out!Īm in need for this solution very badly and what could be a better place than excelforum ! I have even signed into this person's computer as myself (it's a big company network thing) and tried to run the macro and it works fine, so there is nothing wrong with the hardware. It is the same Operating system and the same version of Excel. I have checked Macro Security level and that is the same as mine, Tools - Add-Ins is the same, In Visual Basic, Tools - References is the same as mine. It seems to get a small way through the macro but then stop with no error messages or any sign that it hasn't completed properly. Should be fine and in most cases it is, however there is one user who although they can open the file, can't seem to get the macro to run properly. Now, I need to share this macro with some other people, so basically I've just sent that excel file on to the people that need to use it.
Nothing incredibly fancy but it works fine on my computer. It just takes some information in one format, rearranges it, adds some formatting and performs some calculations. I've written a macro that is relatively simple. I've had a long search through your pages to see if this question has been answered before but having browsed through about 50 pages worth of threads I couldn't see anything, but if I am repeating prior information I do apologise. (although I will keep this little piece of magic out of their knowledge so they don't rely on it, just though it would be a secondary back up to helping eliminate these mishaps cause we are loosing alot of information by people saving overtop of other peoples work and not caring.) but a refresh so the screen actually updates in front of you. Secondly as back up I was wondering if you can create a macro to do a refresh of everyones screens automatically - say every 2 or 5 mins? I don't mean a save. instead of them saving by going to File - Save or cntrl+s ? I just thought that MAYBE having a big button in their face will remind them.
#HOLY MACRO 2500 EXCEL VBA EXAMPLES PDF HOW TO#
How to I create a macro button at the top of the page that is literally a SAVE button. It's nothing fancy, just use it as a PO Book but since it is shared some people continue to not save before they add in more work so that they see a 'refreshed' copy of the workbook before they start writing in cells that already contain information. We have a 'shared' work book we all work in. Here at work, I have some incompentant computer workers who claim they KNOW MS sooo well and have certificates etc. I have been trying to learn macros but have not made one yet.