+ Reply to Thread
Results 1 to 4 of 4

Buttons won't display in Excel

  1. #1
    Registered User
    Join Date
    12-04-2019
    Location
    Auckland NZ
    MS-Off Ver
    365 business premium
    Posts
    3

    Buttons won't display in Excel

    I can create buttons and attach macros that will all work- but the buttons remain invisible on the worksheet. Moving the cursor over them turns cursor to finger point. Some Pivot table sheets I use are highly reliant on buttons to get data or refresh etc so it is important to get these visible again on my setup.
    The problem surfaced when I, reluctantly, moved from Win7 to win10 pro.
    I suspected the graphics driver (AMD Radeon HD7800 card) so downloaded the latest from the AMD site and installed by using the AMD uninstall tool and the autodetect and install tool, Both worked well and the latest driver is installed. But it didn't fix the problem.
    Re-installed office. no change.
    What may be another aspect of the same problem is that if I disable Hardware Graphics acceleration in Options - all my Office screens immediately become unreadable and I have to use shortcut keys to restore proper display by unchecking "disable hardware graphics etc.
    All other PCs in the office run win10 and Office 365 and have not had the same issue.
    There is not much point in supplying a sample worksheet as it will work OK on a different pc . I tested this by creating a sheet with buttons on mine and copying that sheet to other pcs. All displayed the buttons.
    Try swapping out the graphics Card??
    Intel 17 cpu 2.67Ghz
    24Gb RAM
    64 bit
    Three displays.

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    Pro 2019
    Posts
    15,157

    Re: Buttons won't display in Excel

    Moving the cursor over them turns cursor to finger point.
    Do they still run if you click them?

    You may have an ActiveX issue. Are you using ActiveX buttons? If so, just to diagnose this, I would try adding a couple of Forms buttons and see if that suffers the same problem.
    Making the world a better place one fret at a time | | |會 |會 |會 |會 | |:| | |會 |會
    Please read the rules
    If someone helped you, click on the star icon at the bottom of their post
    If your problem is solved, go to Thread Tools and select Mark This Thread Solved
    Don't attach a screenshot--just attach your Excel file! It's easier and will let us experiment with your data, formulas, and code.

  3. #3
    Registered User
    Join Date
    12-04-2019
    Location
    Auckland NZ
    MS-Off Ver
    365 business premium
    Posts
    3

    Re: Buttons won't display in Excel

    Just Form Buttons. I just now tried putting an ActiveX button on a work sheet and it remains visible. I think must be a hardware issue- I just cant get my head around why it only appears in Office and not in my other programs like InDesign or Corel or AccountRight.
    Perhaps this thread would be more appropriate to a technical forum??

  4. #4
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    Pro 2019
    Posts
    15,157

    Re: Buttons won't display in Excel

    That surprises me. ActiveX controls have some hiccups in some environments, but Forms controls are usually more predictable. I am not sure how this could be a hardware issue but it is probably something in the guts of your system rather than something that can be addressed through the Excel user interface. You might try running Repair on Office.

+ 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