Consulting

Results 1 to 7 of 7

Thread: VIEW CODE

  1. #1

    VIEW CODE

    Hi all

    Excel icon in right of File Menu in 'Worksheet Menu Bar' contains View Code option. Is it possible to disable the View Code

    I want to disable the xl icon, right click menu,View Code option. is it possible.

    Thank you in advance

    Regards
    Rema

  2. #2
    Knowledge Base Approver VBAX Guru GTO's Avatar
    Joined
    Sep 2008
    Posts
    3,368
    Location
    I feel like I must be missing something, but at the core, are you trying to not allo them (the users) from viewing the vba code that you have written?

    As this command normally opens to the ThisWorkbook module, this was the only goal I could think of...

    Mark

  3. #3
    Yes, not allowing the user to view the vba code.

    i could only find SendKeys option for locking the vba project with password.

    is there a way disable view code option in Excel icon right click menu
    Thank you

  4. #4
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    Protect YOUR projects with passwords, and don't interfere with other people's right to create their own.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  5. #5

    how do you protect your projects?

    Im new to this how can i protect my projetcs

  6. #6
    VBAX Mentor jammer6_9's Avatar
    Joined
    Apr 2007
    Location
    Saudi Arabia
    Posts
    318
    Location
    Quote Originally Posted by khalid79m
    Im new to this how can i protect my projetcs
    In VBA
    1. Tools
    2. VBAProject Properties
    3. Protection
    4. Check "Lock for Viewing"
    5. Enter Passwords
    T-ogether
    E-veryone
    A-chieves
    M-ore


    One who asks a question is a fool for five minutes; one who does not ask a question remains a fool forever.

  7. #7
    thanks dude

Posting Permissions

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