Macro can not unprotect a sheet in a shared workbook
I have a spreadsheet that is shared by our work group. It has a macro that
reads cells on the DataEntry tab and writes to LogSheet tab. The LogSheet tab is protected with a password, so the macro unprotects, writes, then reprotects. This works just fine but when the workbook is shared the macro can not unprotect the sheet. Does anyone know why a macro can not unprotect a sheet in a shared workbook? I think this is Excel 2003 in Windows XP, but some of the stations might be Excel 97 on Win 2000, which might be the root of this problem. |
Macro can not unprotect a sheet in a shared workbook
Mike, see ProtectSharing and UnprotectSharing in VBA help files.
"Mike H" wrote in message ... I have a spreadsheet that is shared by our work group. It has a macro that reads cells on the DataEntry tab and writes to LogSheet tab. The LogSheet tab is protected with a password, so the macro unprotects, writes, then reprotects. This works just fine but when the workbook is shared the macro can not unprotect the sheet. Does anyone know why a macro can not unprotect a sheet in a shared workbook? I think this is Excel 2003 in Windows XP, but some of the stations might be Excel 97 on Win 2000, which might be the root of this problem. |
Macro can not unprotect a sheet in a shared workbook
Changing sheet protection is one of the many features that is not available in
shared workbooks. Check excel's (not VBA's) help for a larger list. Mike H wrote: I have a spreadsheet that is shared by our work group. It has a macro that reads cells on the DataEntry tab and writes to LogSheet tab. The LogSheet tab is protected with a password, so the macro unprotects, writes, then reprotects. This works just fine but when the workbook is shared the macro can not unprotect the sheet. Does anyone know why a macro can not unprotect a sheet in a shared workbook? I think this is Excel 2003 in Windows XP, but some of the stations might be Excel 97 on Win 2000, which might be the root of this problem. -- Dave Peterson |
Macro can not unprotect a sheet in a shared workbook
The knowlegebase article 263564 says if a shared workbook is protected but
does not have a password, the workbook remains shared after you remove the protection. That's how mine should work but I didn't get a chance to check it out today, maybe Monday. Mike "Dave Peterson" wrote: Changing sheet protection is one of the many features that is not available in shared workbooks. Check excel's (not VBA's) help for a larger list. Dave Peterson Mike H wrote: I have a spreadsheet that is shared by our work group. It has a macro that reads cells on the DataEntry tab and writes to LogSheet tab. The LogSheet tab is protected with a password, so the macro unprotects, writes, then reprotects. This works just fine but when the workbook is shared the macro can not unprotect the sheet. Does anyone know why a macro can not unprotect a sheet in a shared workbook? I think this is Excel 2003 in Windows XP, but some of the stations might be Excel 97 on Win 2000, which might be the root of this problem. |
Macro can not unprotect a sheet in a shared workbook
Mike
You are confusing workbook protection with worksheet protection. Not the same thing. Gord Dibben MS Excel MVP On Fri, 18 Dec 2009 17:09:01 -0800, Mike H wrote: The knowlegebase article 263564 says if a shared workbook is protected but does not have a password, the workbook remains shared after you remove the protection. That's how mine should work but I didn't get a chance to check it out today, maybe Monday. Mike "Dave Peterson" wrote: Changing sheet protection is one of the many features that is not available in shared workbooks. Check excel's (not VBA's) help for a larger list. Dave Peterson Mike H wrote: I have a spreadsheet that is shared by our work group. It has a macro that reads cells on the DataEntry tab and writes to LogSheet tab. The LogSheet tab is protected with a password, so the macro unprotects, writes, then reprotects. This works just fine but when the workbook is shared the macro can not unprotect the sheet. Does anyone know why a macro can not unprotect a sheet in a shared workbook? I think this is Excel 2003 in Windows XP, but some of the stations might be Excel 97 on Win 2000, which might be the root of this problem. |
All times are GMT +1. The time now is 08:09 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com