When you are done editing the macros, you can save them without ever needing to make the workbook visible. Instead, display the VBA editor and use the object browser to make sure you are working on the macros in the Personal.xlsb workbook. First, if you are only making changes to macros in Personal.xlsb, you don't need to unhide the workbook to work on those macros. There are a couple of things you need to keep in mind. He wonders if there is a way to automatically force Personal.xlsb to be hidden if he forgets to hide it manually. Since it looks like a new, blank worksheet, he often starts typing in it and this messes up his Personal.xlsb workbook. ![]() If he forgets to hide it again when he is done, then the next time he starts Excel the Personal.xlsb workbook is immediately visible. When he needs to work on it, he unhides it. Ken is having a problem with his Personal.xlsb workbook.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |