[will07]

Hello Everbody

Is it possible to turn off the option to insert worksheets into a workbook?

I have prtoected the worksheet so that rows and columns cannot be inserted
but need to prevent any user from inserting extra worksheets into the workbook
Thanks

[Bernard Liengme]

Have you tried Tools | Protect | WorkBOOK ?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"will07" wrote in message
...
Hello Everbody

Is it possible to turn off the option to insert worksheets into a
workbook?

I have prtoected the worksheet so that rows and columns cannot be inserted
but need to prevent any user from inserting extra worksheets into the
workbook
Thanks

[will07]

Thanks Bernard,

it worked well, i originally thought you had to add a password.

Thanks

"Bernard Liengme" wrote:

Have you tried Tools | Protect | WorkBOOK ?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"will07" wrote in message
...
Hello Everbody

Is it possible to turn off the option to insert worksheets into a
workbook?

I have prtoected the worksheet so that rows and columns cannot be inserted
but need to prevent any user from inserting extra worksheets into the
workbook
Thanks