Deleting worksheets
 

I have a workbook with a number of sheets. The workbook is to be distributed
to other users and I'd like to stop them from deleting any of the worksheets.

Can this be done?

Any help gratefully appreciated.

Deleting worksheets
 

David,

Excel protection is not very robust. However this will do what you want

Tools - Protection - protect workbook and ensure that structure is checked.
Apply a password.

Mike

"David" wrote:

I have a workbook with a number of sheets. The workbook is to be distributed
to other users and I'd like to stop them from deleting any of the worksheets.

Can this be done?

Any help gratefully appreciated.

Deleting worksheets
 

Thanks Mike,

That'll be enough to stop the people concerned!

David

"Mike" wrote:

David,

Excel protection is not very robust. However this will do what you want

Tools - Protection - protect workbook and ensure that structure is checked.
Apply a password.

Mike

"David" wrote:

I have a workbook with a number of sheets. The workbook is to be distributed
to other users and I'd like to stop them from deleting any of the worksheets.

Can this be done?

Any help gratefully appreciated.