Unhide personal workbook - durable solutions
Where is the Personal Macro Workbook?
In Windows 10, Windows 7, and Windows Vista, this workbook is saved in the C:\Users\user name\AppData\Local\Microsoft\Excel\XLStart folder. In Microsoft Windows XP, this workbook is saved in the C:\Documents and Settings\user name\Application Data\Microsoft\Excel\XLStart folder.
In the third article, we will teach you how to create this Yes / No message box that will appear before your macro runs so that you don't if you accidentally run the macro and ruin your workbook or worksheet, that should be all to get you started using the personal macro workbook and it will definitely save you a lot of time using excel so i am going to show you how to create the personal macro workbook but before i do that i want to explain exactly what it is so i like to think of this as your tool belt for excel or ladies, you can think of it as your handbag and basically it just contains all of your personal macros or the tools you will be using to do the Days to survive. These are tools or macros that will help you automate processes that will help save you time when you work with Excel so that the personal macro workbook is just an Excel workbook that is saved or saved on your computer and him contained macros or a lot of code so here is mine that we can see in the wallet in VBeditor I have this personal dot XLS-B file This is the personal macro workbook and it just contains a bunch of modules that are code -Modules that I added that contain macros or code that I can run anytime, and the personal macro workbook opens every time you open Excel. It opens in the background and is always available to you, so you can run these macros whenever you want.
You can also add buttons to the ribbon like I have this my Macros Tab right here in Excel This is a custom tab that I added and contains the buttons that run these macros is orkbook and just helps you save your macros and enables You to use them anytime. Okay so let's go ahead and create the personal macro workbook so we can use the macro recorder to do this and we also need the developer tab so when you do if you have the developer tab in the top of the Don't see the Ribbon, you can just enable it Right-click a tab here and choose Customize the Ribbon. This brings up the Excel options window for the custom ribbon tabs and we want to check the box next to Developer to enable the Developer tab so I'll hit OK and that will bring up the Developer tab here on the ribbon.
The Developer tab here just has some buttons for the Visual Basic Editor that records macros for inserting controls into your workbooks and all sorts of different stuff, but we're only going to be using this record macro button here, you can also find it here at the bottom left of the application window click there is a button to record macros so i hit record macro and that will basically bring up this input macro prompt that asked us to create a name, we are actually going to create an amacro here that is called 'addthree Sheets' is called. We're going to add a couple of sheets to the workbook now. The important step is that you want to choose where it says Save Macro in you want to choose a personal macro workbook with this option here and that will actually allow us to create a personal macro workbook for us, so I'll choose that and hit OK and in the background, basically a personal macro workbook is created and stored on our computer.
Now we can actually record a macro, which you can tell by the fact that the 'Developer' tab here is stopping recording and there is also a stop button down here in the lower left corner so I'm just going to do a few things here to to add a couple of sheets I'm going to put some sheets in the workbook, here just three sheets of she ts and that way the macro recorder will actually record these actions, so now I'm going to click stop recording to stop recording and we will will jump into the visual basic editor to see the code so the visual basic button here opens the basic editor the keyboard shortcut isalt f11 so i click on it that opens the visual basic editor here and we can use our personal workbook see our personal macro workbook right here, so basically in the project window on the left you will see a list of all workbooks, ie e are currently open The computer including some of my add-ins here and then we have the personal macro workbook here. If we expand these we can actually see the code modules if we double click on module 1, which will show us the macro we just recorded.Sheets Dot Add is a method that adds a new sheet after the active sheet.
Now we have this macro here in our personal macro workbook and this is basically this workbook is ok saved on the computer and in the following article I will show you exactly where it is saved and how you can view it too, but basically have it we now have our personal macro workbook here and every time we open Excel, this workbook will be there with our macros that we can run and what is really important is that you always have it when you change this or make changes to it want to save personal macro workbook. To do this, you can just hit the save button here in the VB editor so that I just hit that button that saves any changes I made to my personal macro workbook, so as I said in the next article, we'll be looking at it where this map this workbook is stored on your computer and how to view it, and then in a article below we'll look at how to add buttons to the Ribbon to run some of those macros that we use a lot. Please leave a comment below if you have any questions about this article.If you want to learn more about macros and VBA, I have a free three-part article tutorial series that will really help you in the first article we write our first macro and I also explain the Excel Object model if you've ever wondered what the dots between the words mean and in what order the code runs then this article is for you in the second article we automate a common Excel task to create a summary report of all worksheets in the workbook and finally in the third Video we create a user form to export the worksheets from the workbook, you can learn more and sign up for the free training at Excel Campus Comm Slashmacros Again for watching and I'll see you soon
How do I hide a Personal Macro Workbook?
The quickest way to get rid of it is to go to the View tab and click Hide. Now, Personal. xlsb will continue to open but it'll be hidden from view. In this way, you'll still have access to the macros you've recorded, but you won't see that pesky Personal.
Why does excel open my personal workbook?
However, Roger notes that Excel always opens Personal. Normally the worksheet is hidden, unless it has been specifically unhidden and Excel saved. To solve the problem, just start Excel and when the Personal. xlsb file is visible, display the View tab of the ribbon and click Hide in the Window group.
How do I make my Personal Macro Workbook open automatically?
- Display the Excel Options dialog box.
- Click Add-Ins at the left side of the dialog box.
- Using the Manage drop-down list (bottom of the dialog box), choose Disabled Items.
- Click the Go button.
- If the Personal workbook is listed as disabled, select it and then click Enable.
- Close all open dialog boxes.
How to unhide a personal macro workbook in Excel?
How to unhide a personal workbook in Excel To make your personal macro workbook visible, this is what you need to do: On the View tab, in the Window group, click Unhide. In the Unhide dialog box, select PERSONAL.XLSB and click OK.
Is there a way to unhide a workbook?
When I try to edit these, I get an error message to the effect that I need to 'unhide' this workbook in order to do this. How do I 'unhide' this workbook? This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread. In the View tab, click Unhide and then Personal.xlsb
How to unhide personal XLs in Microsoft Office?
Locate the Personal.xls file on your system. It should be in: Program FilesMicrosoft OfficeOfficeXLStart. on the drive where you installed MS Office. Select the file Personal.xls and open it. The Title Bar will show the file name as 'BookN' rather than Personal.xls. Now click on Windows on the Menu Bar then click on Unhide.
How to get rid of hidden workbooks in Excel?
Save 50% of your time, and reduce thousands of mouse clicks for you every day! 1. In Excel, click the View tab, then click Unhide in the Window group. See screenshot: 2. If there is only one hidden workbook, after clicking the Unhide command, the hidden workbook will show up.