turn on sharing
 

I need to turn on sharing after a workbook is open. I've
tried these two lines and both fail. The workbook has
multiple spreadsheets. I also need to turn on the general
workbook protect to prevent users from making any changes.

Workbooks(1).Protectforsharing password:="test", _
SharingPassword:="test"

Workbooks.Protectforsharing password:="Test"

Thanks for any sugestions.


Mark.