G Guest Mar 18, 2005 #1 I have a shared workbook. It is not password protected, but is locked. How do I unlock it?
D Dave Peterson Mar 18, 2005 #2 Do you mean that a worksheet is protected or that the workbook is protected (via tools|protection)? If yes, then look in Excel's help for "Features that are unavailable in shared workbooks", you'll see a big old list. One of them is that you can can't change the protection of a worksheet/workbook in a shared workbook. You'll have to unshare the workbook.
Do you mean that a worksheet is protected or that the workbook is protected (via tools|protection)? If yes, then look in Excel's help for "Features that are unavailable in shared workbooks", you'll see a big old list. One of them is that you can can't change the protection of a worksheet/workbook in a shared workbook. You'll have to unshare the workbook.
