Protecting cells in Excel but allow these to be modified by VBA script

by

Try using 

Worksheet.Protect "Password", UserInterfaceOnly := True

If the UserInterfaceOnly parameter is set to true, VBA code can modify protected cells.

More Related Contents:

  1. to make this code simpler
  2. VBA – How to grab the cell below if a cell has text?
  3. VBA code takes long time to execute in excel
  4. Find text and show value if condition is met
  5. How can I insert variable into formula in VBA
  6. Excel VBA deleting rows in a for loop misses rows
  7. VBA – destroy a modeless UserForm instance properly
  8. What is the lifetime of a global variable in excel vba?
  9. Copy data from another Workbook through VBA
  10. Excel VBA Load worksheet in Function
  11. Searching an excel with two search words (multiple lookup) using vba macro [closed]
  12. Saving a Excel File into .txt format without quotes
  13. Excel VBA – Combine rows with duplicate values in one cell and merge values in other cell
  14. Load csv file into a VBA array rather than Excel Sheet
  15. Insert line break in wrapped cell via code
  16. Change color of certain characters in a cell
  17. Fastest way to delete rows which cannot be grabbed with SpecialCells
  18. Combine multiple Excel workbooks into a single workbook
  19. Excel Macro, inserting internationally valid formula during run-time
  20. VBScript – How to make program wait until process has finished?
  21. Want VBA in excel to read very large CSV and create output file of a small subset of the CSV
  22. Copy filtered data to another sheet using VBA
  23. Range.Find on a Date That is a Formula
  24. VBA Macro crashes after 32000 rows
  25. Range() vs Cells() vs Range.Cells()
  26. How to create dynamic variable names VBA
  27. How to break a long string into multiple lines
  28. Read VBA macros (or vbaProject.bin) of an Excel file without opening it in MS Excel [closed]
  29. simple vba code gives me run time error 91 object variable or with block not set
  30. VBA inheritance, analog of super

Leave a Comment