+ Reply to Thread
Results 1 to 2 of 2

Prevent sheet add or delete

  1. #1
    Glen Mettler
    Guest

    Prevent sheet add or delete

    I have 2 gourps of users for my app - Administrators and Users. I need to
    allow the Administrators to add/delete worksheets but I need to prevent the
    User from adding or deleting a worksheet. I know how to use the IF
    statements but how do I prevent add/delete of a worksheet?

    TIA
    Glen




  2. #2
    Jim Cone
    Guest

    Re: Prevent sheet add or delete

    Glen,

    By protecting the workbook.

    Jim Cone
    San Francisco, USA


    "Glen Mettler" <GlenMettler@knology.net> wrote in message
    news:9WuId.2462$Ah.1997@fe40.usenetserver.com...
    > I have 2 gourps of users for my app - Administrators and Users. I need to
    > allow the Administrators to add/delete worksheets but I need to prevent the
    > User from adding or deleting a worksheet. I know how to use the IF
    > statements but how do I prevent add/delete of a worksheet?
    > TIA
    > Glen



+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1