I might be asking for too much but I thought I would ask! Thank you all for reading and thank you for your time. create the password as a unique cell in the spreadsheet, and 2., have that password only show certain cells in the spreadsheet? All you have to do is open the desired workbook and. from the Tools menu Type in your desired password in the Password to Open field. Anybody who knows the current password can remove or change workbook passwords. In the Save As dialog box, click the Tools drop-down menu near the bottom of the dialog box. That being said, is it possible to do something like this in Excel but 1. Inside Excel, navigate to the Save As dialog box (File Tab > Save As > Browse). I know that Excel currently has something like this set up because (on a separate occasion), I was sent an excel spreadsheet via email and the only way I could view it was if I put in my birthdate as the password (when I opened the spreadsheet). Students have to call or email me for their ID (and it could be a class of 20+) but I was wondering if there was a way that I could send a spreadsheet of the class roster with the student ID numbers and birth dates, and the students can enter their birth date as the "password" to unlock their student ID. I have an online class and in order for students to access their class, they have to create an account with their student ID. In the Allow all users of this worksheet to list, select the elements that you want users to be able to change.Ĭlick OK, and if prompted retype the password.Hello! I work at a community college as a Program Coordinator for non-credit classes. You would need to implement some code to build the actual DataTable, but that should be simple enough. EPPlus supports reading password protected excel files.
Make sure you choose a password you can remember, because if you lose the password, you cannot gain access to the protected elements on the worksheet. Instead of using an OleDbConnection you might consider using an Excel reading library like EPPlus to read the excel file.
Note The password is optional however, if you don't supply a password, any user will be able to unprotect the sheet and change the protected elements. On the Tools menu, point to Protection, and then click Protect Sheet. Unlock any graphic objects you want users to be able to change. Hide any formulas that you don't want to be visible: select the cells with the formulas, click Cells on the Format menu, click the Protection tab, and then select the Hidden check box. Unlock any cells you want users to be able to change: select each cell or range, click Cells on the Format menu, click the Protection tab, and then clear the Locked check box. Switch to the worksheet you want to protect.
Protect worksheet elements from all users
0 kommentar(er)
