![]() |
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 |
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 |
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