Print only unlocked fields

Posted on 2012-08-14
Last Modified: 2012-08-16
Is there a way to print only the unlocked fields.  I have a sheet that has the titles of the data I want to enter.  Then when I print I only want the data entered to print.  Is this possible?

Question by:BOULMAN
    LVL 8

    Accepted Solution

    You can do something like this.

    Sub PrintUnlocked()
        Dim ws As Worksheet
        Set ws = Worksheets("sheet1")
        'If you know the range and is contiguous
        'If you prefer to select the cells
    End Sub

    Open in new window


    Author Closing Comment


    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    This collection of functions covers all the normal rounding methods of just about any numeric value.
    This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
    This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
    This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

    745 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

    16 Experts available now in Live!

    Get 1:1 Help Now