Environment:
-Windows XP Professional SP2
-Excel in Office XP (Version 10.4302.4219) SP2
I have an XLS file, with multiple worksheets in them, each worksheet is password protected, and a lot of cells within them are locked.
I have some VBA code (invoked from a button in each form) that would:
- Unlock the worksheet
- make some changes to the worksheet
- Lock the worksheet
Furthermore, the XLS workbook has been made Shared for editing by multiple users and history kept for 3 days.
All these has been working all along, until today when I get Applicaton defined or object Error. Adding debug lines reveals that the error occurs whilst code is trying to unlock worksheet. I know the "Protect"/"Unprotect" worksheet item is dimmed as the workbook was shared, but don't know why it has been working all along until now!
-Windows XP Professional SP2
-Excel in Office XP (Version 10.4302.4219) SP2
I have an XLS file, with multiple worksheets in them, each worksheet is password protected, and a lot of cells within them are locked.
I have some VBA code (invoked from a button in each form) that would:
- Unlock the worksheet
- make some changes to the worksheet
- Lock the worksheet
Furthermore, the XLS workbook has been made Shared for editing by multiple users and history kept for 3 days.
All these has been working all along, until today when I get Applicaton defined or object Error. Adding debug lines reveals that the error occurs whilst code is trying to unlock worksheet. I know the "Protect"/"Unprotect" worksheet item is dimmed as the workbook was shared, but don't know why it has been working all along until now!