Preventing users from adding worksheets

[McNiwram]

Hi folks

I created an excel template with about 8 worksheets in it.
I then send this template out to about 15 people for them
to fill in the cells. However, some of the receipients
tend to add unnecessary worksheets to the workbook for
their own personal purposes. How can I prevent users from
adding (or removing) worksheets in my template without
having to prevent them from filling in important
information in the 8 worksheets I've originally created?

Cheers

 

[JE McGimpsey]

One way:

Tools/Protection/Protect Workbook...

Realize however, that this protection is just about worthless if someone
really wants to add a sheet. See

http://www.mcgimpsey.com/excel/removepwords.html

 

[CLR]

Tools > Protection > Protect Workbook >Structure

Vaya con Dios,
Chuck, CABGx3