Sheet protection: UserInterFaceOnly gone

by

You can’t do it without reapplying UserInterfaceOnly:=True after reopening the workbook. Taken from Excel’s Vb protect method reference:

If you apply this method with the UserInterfaceOnly argument set to true and then save the workbook, the entire worksheet (not just the interface) will be fully protected when you reopen the workbook. To re-enable the user interface protection after the workbook is opened, you must again apply this method with UserInterfaceOnly set to true

Now, if your concern is that this takes too long (15 seconds, as you say), take a look at this Code Review answer. I have done this in several workbooks of varying level of complexity, and the time for reapplying protection is negligible in all versions I’ve tried, including 2010.

More Related Contents:

  1. VBA – How to grab the cell below if a cell has text?
  2. Getting ScriptControl to work with Excel 2010 x64
  3. Pop up the Excel Statusbar?
  4. Get list of Excel files in a folder using VBA [duplicate]
  5. When one should use Set [e.g for SpecialCells return value]?
  6. Should I turn .CutCopyMode back on before exiting my sub procedure?
  7. Determine if cell contains data validation
  8. VBScript – How to make program wait until process has finished?
  9. Removing the password from a VBA project
  10. How to highlight a cell using the hex color value within the cell?
  11. Removing special characters VBA Excel
  12. Open an Excel file from SharePoint site
  13. VBA recognizing workbook by partial name
  14. Excel VBA wildcard search
  15. How do I loop an excel 2010 table by using his name & column reference?
  16. Excel VBA Project has generated multiple Workbook objects
  17. Copy an entire worksheet to a new worksheet in Excel 2010
  18. VBA code takes long time to execute in excel
  19. What is the difference between “Form Controls” and “ActiveX Control” in Excel 2010?
  20. What is the lifetime of a global variable in excel vba?
  21. How to check for empty array in vba macro [duplicate]
  22. Use autofilter on more than 2 criteria
  23. Compiler Error: User-defined types not defined
  24. Open a workbook using FileDialog and manipulate it in Excel VBA
  25. Vba Excel do vlookup from a closed file
  26. Want VBA in excel to read very large CSV and create output file of a small subset of the CSV
  27. VBA Macro crashes after 32000 rows
  28. How to break a long string into multiple lines
  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