Hi,

I am confussed with this problem.

I have a workbook on our network drive. When ever I work on it, I protect
the sheet, then the workbook and later on I use the, protect and share
workbook option.

When I wrote a code to do the above mentioned task. I am able to protect the
sheet and the workbook, but the option of protect and share workbook is
grayed out.

Please help.

Regards
Heera Chavan