Excel: VBA automatically lock down spreadsheet with exceptions
Experts:
I am trying to not have to select every item on my spreadsheet to lockdown while ensuring that my listboxes, buttons, and pictures w/macros are clickable. Is there away to write a VBA script that will do this?
Please see attached file NOC-Reports-r29.xlsm
I am trying to not have to select every item on my spreadsheet to lockdown while ensuring that my listboxes, buttons, and pictures w/macros are clickable. Is there away to write a VBA script that will do this?
Please see attached file NOC-Reports-r29.xlsm
rspahitz
so you're trying to lock all the cells? why not just set the lock property of the cells to locked (the default) and the lock property of the controls to not locked, then turn on Protection? You can lock all cells that have their lock status enabled on demand.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.