How to eliminate buttons gotten after importing table.

Posted on 2012-09-06
Last Modified: 2012-09-06

Please refer to attached file. Please help me eliminating the buttons that show up in the rightmost column of data and also in the bottommost row of data.

Can you please describe the method for future tasks?

Thank you.
Question by:capterdi
    LVL 92

    Expert Comment

    by:Patrick Matthews
    You can't.  Those are embedded HTML form controls, and they always show vertical and horizontal scroll bars.

    You only see them on the right-most column and the bottom-most row because the scroll bars for the other objects are "hidden" underneath their neighboring controls.
    LVL 39

    Accepted Solution

    Agreed with Patrick, but you can convert these html textboxes into cell values by running the macro below:

    Sub dafsd()
    Dim oleObj As OLEObject
    For Each oleObj In ActiveSheet.OLEObjects
        If TypeOf oleObj.Object Is msforms.TextBox Then
            oleObj.TopLeftCell.Value = oleObj.Object.Value
        End If
    End Sub

    Open in new window


    Author Closing Comment

    Outstanding Thomas.

    Thanks a lot.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    A2 = A1 That kind of cell reference is relative.  If you copy it from A2 to B2, then B2 will get this: B2 = B1 That's all fine and good, but if you then insert a new row above row 2, you'll find: A3 = A1 B3 = B1 This is intentional. …
    This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
    The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
    This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

    759 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

    11 Experts available now in Live!

    Get 1:1 Help Now