ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Insert Worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/191034-insert-worksheet.html)

will07

Insert Worksheet
 
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

Insert Worksheet
 
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

Insert Worksheet
 
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






All times are GMT +1. The time now is 03:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com