Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 229
  • Last Modified:

How to eliminate buttons gotten after importing table.

HI,

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.
Book3.xls
0
capterdi
Asked:
capterdi
1 Solution
 
Patrick MatthewsCommented:
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.
0
 
nutschCommented:
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
        oleObj.Delete
    End If
Next

End Sub

Open in new window


Thomas
0
 
capterdiAuthor Commented:
Outstanding Thomas.

Thanks a lot.

Carlos
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now