Unlocking specific cells in an Xcel locked worksheet.
Posted on 2013-01-22
I write VB Xcel programs for local organizations - the purpose is to create summary reports from database worksheets. Saves the organization mucho time.
I also need to have the summary report worksheet locked so the organization workers do not change the structure of the summary report which would display data in the wrong cells.
My problem is that I also need to have some of the cells in the locked summary report worksheet not locked. The purpose is to have the user select the worksheet used by VB, ie, current year or previous year database worksheet for example.
When entering VB sub I unlock the worksheet with: ActiveSheet.Unprotect
And when exiting the sub: ActiveSheet.Protect.
Need to keep the user needed data entry cells unlocked.
Any help would greatly appreciated.