![]() ![]() However, the file contains 8 sheets that are all identically laid out, except the number of rows is different. I have set up an auto-execute macro which automatically sets the zoom factor to best fit, for several of the worksheets, and this works fine.īy repeating this code for each worksheet, I can make each one be zoomed just right. I have set it up so that everything looks OK and is visible on MY screen, but I'm conscious that some users may have different screen sizes, different toolbars set up, and so on, which might make some parts not immediately visible to them. I have set up a workbook that is sent out to lots of different users. (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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |