+ Reply to Thread
Results 1 to 5 of 5

Can't click button and Properties doesn't show up

  1. #1
    Forum Contributor
    Join Date
    08-10-2014
    Location
    Alberta
    MS-Off Ver
    2016
    Posts
    128

    Can't click button and Properties doesn't show up

    This may be a computer settings issue, but as it deals with excel VBA, I figure I should ask.

    I have a VBA program that I created on Excel 2013 with Windows 8.1 that works fine. I transferred the program onto a tablet (I did not manage the settings) that is Excel 2013 with Windows 8.1 as well. However, when I go into the program on the tablet, I am unable to click (or tap) any of the buttons that previously worked. When I go into Design Mode and click on the button, then I look at the Properties of that button, it doesn't get recognized. I then go to add a button and I get a msgbox that pops up saying "Cannot insert object."

    I even tried making a new worksheet and I am unable to insert an Active X button. I went into the Trust Center but the changes do not seem to make any difference.

    How can I fix this?

  2. #2
    Forum Contributor
    Join Date
    08-10-2014
    Location
    Alberta
    MS-Off Ver
    2016
    Posts
    128

    Re: Can't click button and Properties doesn't show up

    Does anyone have any ideas what could be wrong?

  3. #3
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Can't click button and Properties doesn't show up

    Hi Templemind

    See this Link

    http://excelmatters.com/2014/12/10/o...ivex-controls/
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  4. #4
    Forum Contributor
    Join Date
    08-10-2014
    Location
    Alberta
    MS-Off Ver
    2016
    Posts
    128

    Re: Can't click button and Properties doesn't show up

    Thank you. I think I have it fixed. I did updates and just fixing it.

  5. #5
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Can't click button and Properties doesn't show up

    You're welcome...glad I could help. Thanks for the Rep.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Button Click on Spreadsheet commanded by Button Click on Userform
    By Quilie19 in forum Excel Programming / VBA / Macros
    Replies: 33
    Last Post: 04-07-2015, 11:35 PM
  2. Changing cell properties with double click, then revert with another double click
    By mweber2525 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 03-01-2014, 01:40 PM
  3. [SOLVED] click on a color button and after button click it will color entire row of cell you click
    By swade730 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-11-2014, 06:06 PM
  4. Replies: 0
    Last Post: 04-09-2013, 04:29 AM
  5. Recording new excel macro, relative reference button doesn't show
    By Dano in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 08-23-2005, 03:05 PM

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