+ Reply to Thread
Results 1 to 2 of 2

Activex text boxes that disappear

  1. #1
    Registered User
    Join Date
    08-02-2012
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    7

    Activex text boxes that disappear

    Hi

    I have a report I am creating in excel 2007, it is spread over several worksheets and each worksheet requires a text box, I have choosen to use activex boxes due to the flexiability with being able to set tab functions etc. The problem I am having is that when you click into them the disappear and you then have to click out for them to re-appear. I don't have a problem with this as I am confident enough in my typing and IT skills to be able to make it work but a few of the people who will be required to use the report are not. Is there any way that I can stop this happening?

    Thanks

  2. #2
    Forum Contributor dogberry's Avatar
    Join Date
    07-15-2012
    Location
    Wales, UK
    MS-Off Ver
    Excel 2010
    Posts
    624

    Re: Activex text boxes that disappear

    Hi
    If you look at your tabs at the top you will see one of them marked Insert click on that tab, the second one is table. So first click inside your range to make it active, then click on table. That will convert your range to a table.

    Chris

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1