Excel - A macro to protect a workbook

December 2016



Issue


I want to protect my Excel workbook and the spreadsheets it contains.

The application I developed with Excel, contains menus, and buttons and graphics that change depending on the responses of a user (mcq). If I do not touch anything at the basic protection (everything is protected) and the user can only view data without interaction. If I unprotect certain cells, such as table cells, the user not only modify the data, but also objects like buttons, and that the main problem.

Solution


Try this:
You must unlock your objects (adapt accordingly):
Range("K17").Select  
Selection.Locked = False  
Selection.FormulaHidden = False  

This protect your sheet:
ActiveSheet.Protect DrawingObjects: = True, Contents: = True, Scenarios: = True

If you want to unprotect it:
ActiveSheet.Unprotect


Thanks to 0seb0 for this tip.

Related :

This document entitled « Excel - A macro to protect a workbook » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.