+ Reply to Thread
Results 1 to 2 of 2

Tab question

Hybrid View

  1. #1
    anny
    Guest

    Tab question

    Greetings to all

    When I right click the tab of a worksheet, I get the option to "View Code".
    I'd like to remove this option but have been unsuccessful so far. (both the
    worksheet and workbook are already protected).

    any clues?
    Thanks, anny





  2. #2
    Arvi Laanemets
    Guest

    Re: Tab question

    Hi


    In VBA editor, right-click on your VBA-project, and select Properties.
    Activate Protection tab, check 'Lock project for viewing', and set a
    password.
    Close VBA editor and then workbook. When the workbook is opened next time,
    after selecting 'View Code' the user is asked for password.


    Ari Laanemets


    "anny" <adorr@idirect.ca> wrote in message
    news:uDw1dHEJGHA.984@tk2msftngp13.phx.gbl...
    > Greetings to all
    >
    > When I right click the tab of a worksheet, I get the option to "View

    Code".
    > I'd like to remove this option but have been unsuccessful so far. (both

    the
    > worksheet and workbook are already protected).
    >
    > any clues?
    > Thanks, anny
    >
    >
    >
    >




+ 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