API to permit worksheet/workbook temporary unlock/lock

Is there any API available that could permit unlocking and relocking a spreadsheet or even a workbook using the original settings for lock/unlock?

This would allow a work-around with some of the locked workspace and workbook restrictions. Currently the only way to do this with XLSpadlock is to internally use a password in the .protect and .unprotect functions in the VBA code, possibly slightly obscured.

Unfortunately no, but you could invoke the .protect and .unprotect VBA functions directly with XLS Padlock’s VBA compiler and thus the password will stay outside the Excel workbook file.

Good idea. That’s better than imbedding it in the regular code.


Steve Glanstein

+1 (808) 423-6766

[email protected]

1 Like