How to Lock the data in a cell in excel using vba

by

You can first choose which cells you don’t want to be protected (to be user-editable) by setting the Locked status of them to False:

Worksheets("Sheet1").Range("B2:C3").Locked = False

Then, you can protect the sheet, and all the other cells will be protected.
The code to do this, and still allow your VBA code to modify the cells is:

Worksheets("Sheet1").Protect UserInterfaceOnly:=True

or

Call Worksheets("Sheet1").Protect(UserInterfaceOnly:=True)

More Related Contents:

  1. to make this code simpler
  2. VBA code takes long time to execute in excel
  3. Wait until ActiveWorkbook.RefreshAll finishes – VBA
  4. Excel column number from column name
  5. Pop up the Excel Statusbar?
  6. Excel VBA deleting rows in a for loop misses rows
  7. Execute a command in command prompt using excel VBA
  8. What is the lifetime of a global variable in excel vba?
  9. Download attachment from Outlook and Open in Excel
  10. What is the most efficient/quickest way to loop through rows in VBA (excel)?
  11. Embed picture in outlook mail body excel vba
  12. How to check for empty array in vba macro [duplicate]
  13. Use autofilter on more than 2 criteria
  14. Excel VBA “Method ‘Document’ of object ‘IWebBrowser2’ failed”
  15. Excel VBA – Combine rows with duplicate values in one cell and merge values in other cell
  16. Determine if cell contains data validation
  17. Load csv file into a VBA array rather than Excel Sheet
  18. Insert line break in wrapped cell via code
  19. Change color of certain characters in a cell
  20. Want VBA in excel to read very large CSV and create output file of a small subset of the CSV
  21. VBA Macro crashes after 32000 rows
  22. TextJoin UDF For Excel 2013
  23. Open an Excel file from SharePoint site
  24. How to create dynamic variable names VBA
  25. How to break a long string into multiple lines
  26. Read VBA macros (or vbaProject.bin) of an Excel file without opening it in MS Excel [closed]
  27. simple vba code gives me run time error 91 object variable or with block not set
  28. How do I open a file if I only know part of the file name?
  29. VBA recognizing workbook by partial name
  30. VBA inheritance, analog of super

Leave a Comment