Hide Macro Menu In Excel

Posted on 2004-11-22
Last Modified: 2013-12-26

I have one problem. I do not know how to hide Macro menu in Excel. The reason why i need to hide the Macro menu is because i don't want user to look at macro code. If this idea cannot work, can anyone tell me how to prevent user from looking at macro code. The main idea is how to prevent user from looking at macro code and also prevent user or anyone from changing the macro code. Ok, I hope anybody can help solve the problem.

Question by:senico
    1 Comment
    LVL 9

    Accepted Solution

    In VBA go to Tools--> VBA ProjectProperties and select the security tab.
    The set a password and users can only view the code when the enter the correct password

    Good luck

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    I’ve seen a number of people looking for examples of how to access web services from VB6.  I’ve been using a test harness I built in VB6 (using many resources I found online) that I use for small projects to work out how to communicate with web serv…
    Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
    Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
    Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now