![]() I try my best to help everyone out, but sometimes I don't have time to fit everyone's questions in (there never seem to be quite enough hours in the day!). Hello, I have just upgaded from 2011 to 2016 and my macro to open a file no longer works. #Open personal macro workbook excel 2016 codeAdd the code to a new PERSONAL.XLSB, save it, resize Excel to a normal window and close it. ![]() Private Sub WorkbookOpen () Application.WindowState xlMaximized. ![]() An interesting thing happens when you use WorkbookOpen instead in the code module ThisWorkbook. I can guarantee 9 times out of 10, one of my strategies will get you the answer(s) you are needing faster than it will take me to get back to you with a possible solution. I can confirm that Excel 2016 crashes with that macro. I highly recommend that you check this guide out before asking me or anyone else in the comments section to solve your specific problem. In the Store macro in box, select Personal Macro Workbook. Hope this helps anyone who needs to find this file. Sub FindPersonalMacroWorkbook() Dim path As String path Application.StartupPath MsgBox path End Sub Hidden items will need to be selected in your file explorer to see where this is. Make sure you don’t use any spaces in the name. You can find the file PERSONAL.XLSB by using the code below. In the Record Macro dialog box, type a meaningful name for the macro in the Macro name box. On the Developer tab, click Record Macro. To create the personal workbook, you first need to create a macro and store it in the Personal Macro Workbook. #Open personal macro workbook excel 2016 updateThat's why I want to share with you: My Guide to Getting the Solution to your Problems FAST! In this article, I explain the best strategies I have come up with over the years to getting quick answers to complex problems in Excel, PowerPoint, VBA, you name it! Create and update the Personal Macro workbook. ![]() We all have different situations and it's impossible to account for every particular need one might have. Visual Basic Coding: Private Sub WorkbookOpen() Sheets(Sheet1).Select. Follow these easy steps below as we explain how this can be done. How Do I Modify This To Fit My Specific Needs?Ĭhances are this post did not give you the exact answer you were looking for. By creating the simple macro given below, one can land on a specific Excel worksheet and even a specific cell when opening a workbook. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |