M
Mark.
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.
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.