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. 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.
0 kommentar(er)
