+ Reply to Thread
Results 1 to 2 of 2

Disappearing button issue

  1. #1
    Forum Contributor
    Join Date
    03-23-2012
    Location
    Michigan
    MS-Off Ver
    MS365 Excel version 2301 (Build 16026.20238)
    Posts
    101

    Disappearing button issue

    Hi. I'm adding a button to my worksheet that runs a macro, and I have that section of the worksheet hidden at times. That section gets unhidden if/when a person selects a specific item from a validated list in a cell in another part of the worksheet. All that works fine, except when I save and close the workbook, when I reopen the workbook and unhide that section, the button is gone. I've even coded it in the macro to unhide that specific button, but it's just gone? Where might it go? Is it still hidden, or does that process somehow destroy the button? Thanks for any advice.

    Frank

  2. #2
    Forum Contributor
    Join Date
    03-23-2012
    Location
    Michigan
    MS-Off Ver
    MS365 Excel version 2301 (Build 16026.20238)
    Posts
    101

    Re: Disappearing button issue

    Hi. I've figured this out. The properties of the button were set to move and size with cells, so when the section got hid, the button would move up and crunch down to about a line, but when it unhid, it didn't move and size back. I was able to find all the buttons by going to the Home tab and selecting Find & Select>Selection Pane to see/confirm the buttons were there, and then Find&Select>Go To Special>Objects to select (i.e., find) all of the objects. I'm good to go now. I hope this maybe helps someone else.

    Frank

+ 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