It should be noted that it's generally a good idea to create a backup copy of your file without a password in case you forget it. I have one staff member that does the data entry but I don't want them to see the 2nd sheet. Dan Hi Chadoo, I am working on an Excel 2013. Then, after unlocking the cells that you still want to be able to change, protect the worksheet as described earlier. Windows 10 Professional users have a built-in encryption utility , but if you want to download a free version with lots of customization options for many types of data, you can try or open source downloads. However it is protecting it without a password.
Aug 19, 2009 I was wondering if it was possible to hide cells using protect sheet? Saved and closed the file as. Post back if you need help with the specific coding. In the Protect Worksheet dialog box, all worksheets within the workbook are listed into the list box, please choose the worksheets that you want to protect. To make changes, click Unprotect Sheet in the Review Tab you might need a password. Tip: You can select multiple, non-contiguous cells by pressing Ctrl+Left-Click. Excel for Office 365 Excel for Office 365 for Mac Excel 2019 Excel 2016 Excel 2019 for Mac Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 To prevent other users from viewing hidden worksheets, adding, moving, deleting, or hiding worksheets, and renaming worksheets, you can protect the structure of your Excel workbook with a password.
You need better encryption with higher versions of Excel, longer and more random passwords, and extra encryption on top of the security provided by Excel. I tried saving the file as xlsm also but not positive, it worked fine; but by creating a dummy procedure. It's also possible to protect macros in the workbook from being removed or changed. We were going to get a stable version. However, later versions of Excel use more sophisticated methods of encryption and therefore the password length and complexity does matter. Commenting privileges may be curtailed if inappropriate images are posted. I would like to be able to password protect a single tab within a workbook.
Mar 15, 2007 i want to protect or give password in only one cell plz let me know how can i do this reply me as soon as possible i m in touble to give password in one cell i want when i try to put any thing on that cell it will Nov 30, 2009 I need to make my spreadsheet require a password to open. Customer data or trade secrets even hidden have no business in a workbook that is distributed outside the company, due to liability reasons. If they don't, then the next time the workbook is open, the worksheet remains unprotected and anyone can change the contents of columns E and J. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. By default, Excel selects the Protect Worksheet and Contents of Locked Cells check box at the top of the Protect Sheet dialog box. Pressing Ctrl+A will do the trick.
Weak passwords don't mix these elements. Tom, I have to keep the spreadsheets as user friendly as possible. Next time, when you open this workbook, and want to make the veryhidden sheets be visible, you are requested to enter a password. Jul 2, 2012 the following macro, changes a few cells etc, then protects the sheet. I don't think this way works in 2007. What, pray tell, is its name? For example, suppose you have tables of data on 3 different tabs, all having the same headings. Hi all, I've been getting this error on occasion recently.
Plus, you never have to give out the password that you used to protect the entire worksheet. But the rest of the worksheet is going to be unprotected for now. The workbook has only a single worksheet, and she needs to protect columns E and J so they cannot be changed, unless the user knows a particular password. Excel displays the Protect Sheet dialog box. Learning is the whole reason why this blog exists! See the subsequent section for more information on how to enable sheet protection.
Also I want to have it as a shared workbook so I can have the hidden history sheet, so I can tract who and when an error is made. Protect your sheets using the Protect Workbook and Protect Sheet options. The first allows you to prevent users from changing anything in the scenario when worksheet password protection is enabled. I found another alternative solution. Is there a way to copy or save it as a different file that will not copy the password protection? How secure is this protection? To ask you, where the number of the worksheets are: ' --- make sheet 1, 3, 5, 7 hidden Worksheets 1.
Insert hyperlinks Insert new hyperlinks, even in unlocked cells. Alanda Thnx for your help man. Jul 22, 2008 I know of the password protect feature to open a excel file or workbook, but does anyone know if this can be done for opening a worksheet. Or would you have to manually update the filter criteria in Sheets 2 and 3? I have a workbook with 7 tabs. I don't want anybody else besides these two people to be able to even open the file, so I'm not talking about password protecting to prohibit editing a file. When a pop-up window appears, select your options and type in the desired password. Added a new sheet 2.