Allow user to add/move sheet when workbook protected

[theDrew]

Hi there,

I have an Excel 2007 workbook with all sheets protected and the workbook protected. Is there any way to allow the user to copy or add sheets? It seems as if the workbook protection feature is all-or-nothing.

 

[capparfrank]

I don't believe that individual permissions can be managed this way. A protected workbook structure is all or nothing.

 

[theDrew]

I was afraid of that. Thanks anyway.

 

[Smitty]

With a protected workbook, the only way to do it is write code that unprotects the wb, adds/copies a sheet, then reprotects.

 

[theDrew]

With a protected workbook, the only way to do it is write code that unprotects the wb, adds/copies a sheet, then reprotects.

Awesome. Worked like a charm.