![]() ![]() DEVELOPER TAB IN EXCEL 2013 HOW TOThe Developer tab is not visible by default in Excel, but heres how to make sure it remains displayed on your system. The following figure shows the File tab in Office 2013. Are you trying to follow a tutorial or guide online that is telling you to select an option on the Developer tab in Excel 2013 If so, then you may have noticed that you don’t have a Developer tab. The Developer tab of the ribbon is the gateway to many advanced features in Excel, including those features related to working with macros. ![]() The following figure shows the File tab and Options button in Office 2010. On the File tab, choose the Options button. See the Applies to: note earlier in this topic. You'll want to select one of the less stringent settings, probably "Disable All Macros with Notification." When you restart Excel, you'll be asked if you want to enable any macros that may be in the workbook. Start any of the Office applications supported by this topic. There are four settings for macros if the "Disable All Macros without Notification" radio button is selected, then the macro capabilities of Excel will be disabled. Excel displays the same Trust Center Settings dialog box mentioned in the previous paragraph. If you prefer, you can display the Developer tab in Excel and then click the Macro Security tool. Check the settings in the Trust Center (display the Excel Options dialog box, click Trust Center, and then click Trust Center Settings) to make sure that you allow macros. If you weren't asked about enabling macros when you opened the workbook, it could be because of the security level you have set on Excel itself. If you don't enable them, then the security setting on the workbook is set to a high enough level that the macros (and doing anything with the macros) are disabled. For instance, when you first open the workbook, you may be notified that it contains macros and asked if you want to enable them. There are any number of reasons why the options would not be available, but they all boil down to security settings for the workbook. She wonders why they are disabled and how she can make them available. Micky noted that when she opens a particular workbook in Excel and displays the Developer tab on the ribbon, some of the tools are disabled (Macros, Visual Basic Editor, Record Macro). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |