Hi
How can I stop someone from adding worksheets to a workbook?
Thanks
Hi
How can I stop someone from adding worksheets to a workbook?
Thanks
Good morning John Calder
Use Tools > Protection > Protect Workbook. This will do the trick, but you haven't given much information in this post so it may stop you doing other things that you intend to do with the file.
Also, bear in mind that this security isn't that strong and can be removed fairly easily.
HTH
DominicB
You can password protect the workbook, however Excel protection is weak and
easily overcome by anyone with a little knowledge and the will to do so,
Regards,
Alan.
"John Calder" <[email protected]> wrote in message
news:[email protected]...
> Hi
>
> How can I stop someone from adding worksheets to a workbook?
>
>
> Thanks
Just to add, you'll want to check the structure box in the
tools|protection|protect workbook dialog.
This will also stop users from renaming, moving or deleting sheets, too.
John Calder wrote:
>
> Hi
>
> How can I stop someone from adding worksheets to a workbook?
>
> Thanks
--
Dave Peterson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks