Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Unable to Insert Worksheet/Move and copy worksheet Excel 2003 | Excel Worksheet Functions | |||
Wish to add a WORKSHEET but 'WORKSHEET' not open in 'INSERT' | Excel Worksheet Functions | |||
Why can't I insert a row in my worksheet? | New Users to Excel | |||
Can I auto insert a worksheet when I insert a value in a cell. | Excel Worksheet Functions | |||
Insert A Worksheet using VBA | Excel Discussion (Misc queries) |