API to permit worksheet/workbook temporary unlock/lock

XLS Padlock
1

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.

2

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.

3

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

Thanks.

Steve Glanstein

+1 (808) 423-6766

[email protected]

1 Like