- #What is document inspector in excel how to#
- #What is document inspector in excel code#
To rename the new sheet, double-click the sheet tab, and type a single. To insert a blank sheet, select the last sheet in a group, then click. To add visual separation between the coloured sheet groups, add a spacer The sheet tabs, to identify the sections, such as data entry and reports. Thanks to AlexJ for sending this Spacer Tab tip. Click OK, twice, to exit the Option settings. In the Document-specific Settings section, remove the check mark from "Remove personal information from file properties on save". In the list at the left, click Privacy Options. At the right, click the Trust Center Settings button. In the list at the left, click Trust Center. At the top left corner of Excel, click the File tab. NOTE: No other workbooks will be affected by the change to this setting. If you're tired of seeing that message, follow these steps to turn it off, in the active workbook. 
Turn Off the Personal Information Warning If you click OK in that warning message, another message appears: "Document not saved." Here's a screen shot of the error message - I put the text onto 2 lines, so it's easier to read. "Be careful! Parts of your document may include personal information that can't be removed by the Document Inspector.".In some Excel workbooks, when you try to save the file, you'll see a warning message: The written instructions for spacer tabs are below the
#What is document inspector in excel how to#
This video shows how to use navigation arrows, worksheet list,Ĭoloured tabs, and spacer tabs, to make it easier to find a specific sheet. It can be difficult to find a specific sheet, if an Excel file has many StrFile = Left(strName, Len(strName) - lExt) MsgBox "Please save the file and then try again." The copy has the same file name and extension, with the date and time added to the end of the name.įor example: MyFileName_20190627_0905.xlsx Sub QuickBU_SameFolder()
#What is document inspector in excel code#
The code below will save a copy of the active workbook, in the same folder. Here's an Excel workbook backup macro that I use almost every day.Ĭopy this macro code, and paste it into a regular code module in a workbook that's always open, when you use Excel, such as your Personal Macro Workbook.
To copy the sheet, check the create a copy box (leave the check box. In the Move or Copy window, click the arrow in the drop down list. 
Right-click on the sheet tab (or, select a group of sheets, and right-click. To move or copy worksheet(s) to a new workbook: With just a few clicks, you can create a new workbook, from an existing Watch this video to see the steps for creating a copy of the originalįile, without using the Save As command. Video, to open a copy of the original, and keep it safe from changes. However, it is easy to forget that step, and you end up making unwantedĬhanges to the original file. Instead of creating an Excel file from scratch, you can save time byīasing the new workbook on an existing file. More Excel Tips and Tutorials Video: Create Workbook Copy Without Save
0 kommentar(er)
