a. Open your Excel workbook. b. Click on the worksheet tab you want to protect for a specific user. c. Right-click on the worksheet tab and select "Protect Sheet." d. In the "Protect Sheet" dialog box, you can set a password if desired, but as mentioned earlier, password protection...
In the Protect group, click Protect Sheet. Clear the check boxes 'Select locked cells' and 'Select unlocked cells'. If you wish, enter a password that will be needed later on to unprotect the worksheet. Don't forget this password! Click OK. If you provided a password, you will have to...
Forum:Excel Questions D Locking Certain Cells I am trying to lock/protect certain cells so that they can't accidentally be deleted or changed, yet still be able to edit the other cells. I don't want to use a password to unlock the sheet everyday, just if I need to adjust those prote...
Sheets("Sheet3").Copy ActiveWorkbook.SaveAs Filename:="C:\My Documents\" & SaveMeAs End Sub Vba - Opening Password Protected Workbook? - Excel Hi I need to open a password protected workbook using VBA. I've tried the code below but I still get prompted for a password. ...
When you start excel, all cells are locked, but not protected. To lock cells, you must enable "protect sheet" (under tools -> protection -> protect sheet). You can either enter a password or leave it blank. To lock or unlock specific cells, click on the cell(s), row, ...
Delete Query is Performing too slow with around 6 million records to delete DELETE RECORDS FROM VIEW Delete Records where total amounts equal 0 delete row or sheet in excel from query Delete statistics option is disabled when you try to delete statistics in sql server Delete top 1000 rows from...
Excel sheet with spaces excel stays live as a process when terminating a program during debug ExcelDataReader to import data from excel spreadsheet error Exception Cannot perform 'Like' operation on System.Int32 and System.String. Exception casting to SQLException Exception from HRESULT: 0x8001010A ...
To protect the worksheet, select the Review Tab, then "Protect Sheet". Check only the boxes, "Protect worksheet and contents of locked cells" and "Select unlocked cells". (Optional) At the top of this prompt, enter a password required to unprotect the sheet. Reply ...
Hello, i have a result (number) in a cell as a result of a successful IF function, which is controlled on the sheet under an auto-refresh. I want to 'lock' or leave, the value in the cell after the I... Locky81 That probably requires VBA code, but we'd need to have more de...
Like password protecting the tables, so that i have access to changing them, but no one else can change the design or the data in datasheet view. Sort by date Sort by votes Jun 16, 2010 #2 MajP Technical User Aug 27, 2005 9,382 US Only way to truly do that is user level ...