Hide formulas VBA

Posted on 2014-08-21
Last Modified: 2014-08-21
I have formula in a spreadheet/excel tool im building

To make the tool look a little more slick, is there anyway i can hide the formula, so its not visible?

Many thanks
Question by:Seamus2626
    LVL 26

    Expert Comment

    Yes. Hiding formulas is recommended so the use doesn't delete or change them by mistake, not only to make it look slick.

    1. Right-click the cells with the formulas, and then select Format Cells.
    2. Click the Protection tab, and check the Hidden checkboxe. Click OK.
    3. On the Review tab, click Protect Sheet.

    Author Comment

    Thanks Macroshadow, i should have elaborated, dependant on a drop down in B31, three things happen

    (1) Text "Enter Target" and user enrters a target
    (2) Formula dropped in
    (3) Formula dropped in

    So the cell cant be protected as one of the options is an edit

    Also, if the formula didnt appear it would look quite slick!

    LVL 26

    Accepted Solution

    I'm not sure I understand. Can you upload a sample.

    Author Comment

    Hold up, i think i get what your saying, let me play about for a minute!

    Author Closing Comment

    Perfect, thanks!

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Join & Write a Comment

    Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asseā€¦
    I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
    This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
    This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

    734 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

    17 Experts available now in Live!

    Get 1:1 Help Now