Unable to protect and share protected workbook through VB

Mudface · Mar 12th, 2002, 07:09 AM

Apologies for starting a new thread, just wondered if anyone had found a way round this: -

ThisWorkbook.Protect Structure:=True, Windows:=False
ThisWorkbook.ProtectSharing sharingpassword:="bobbins"

Doesn't work and gives an invalid procedure call. Removing the first line does work...

Dave Hawley · Mar 12th, 2002, 07:19 AM

Hi Muddy

I'll try another, and yes I have never had to use sharing!

When you use the "ProtectSharing" method does't that protect the Workbook anyway? so putting the "Protect" method first would stop the "ProtectSharing" method.

In a few word, do you need the "Protect" and if so try it last.

Mudface · Mar 12th, 2002, 07:29 AM

Unfortunately, it doesn't protect the workbook's structure, no, and once you've protected it for sharing, the option for protecting it's structure or any sheets within it is no longer availble. Nice catch-22.

Note that you CAN protect the workbook structure and then protect for sharing via normal operation, but not in Vb.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 12th, 2002, 07:09 AM	#1
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	Apologies for starting a new thread, just wondered if anyone had found a way round this: - ThisWorkbook.Protect Structure:=True, Windows:=False ThisWorkbook.ProtectSharing sharingpassword:="bobbins" Doesn't work and gives an invalid procedure call. Removing the first line does work...

Mar 12th, 2002, 07:19 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi Muddy I'll try another, and yes I have never had to use sharing! When you use the "ProtectSharing" method does't that protect the Workbook anyway? so putting the "Protect" method first would stop the "ProtectSharing" method. In a few word, do you need the "Protect" and if so try it last.

Mar 12th, 2002, 07:29 AM	#3
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	Unfortunately, it doesn't protect the workbook's structure, no, and once you've protected it for sharing, the option for protecting it's structure or any sheets within it is no longer availble. Nice catch-22. Note that you CAN protect the workbook structure and then protect for sharing via normal operation, but not in Vb.