+ Reply to Thread
Results 1 to 4 of 4

having visiblity changes to autoshapes/command buttons after a macro is completed

  1. #1
    Forum Contributor
    Join Date
    07-22-2009
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    122

    having visiblity changes to autoshapes/command buttons after a macro is completed

    Is there a way that after a macro has been completed which is linked to commandbutton1, to hide command button 1 and display an autoshape?

  2. #2
    Valued Forum Contributor blane245's Avatar
    Join Date
    02-20-2009
    Location
    Melbourne, FL
    MS-Off Ver
    Excel 2010
    Posts
    649

    Re: having visablity changes to autoshapes/command buttons after a macro is completed

    something like this?
    Please Login or Register  to view this content.
    note that the shape that you want to make visible may not be shape #1
    Bob
    Click my star if my answer helped you. Mark the thread as [SOLVED] if it has been.

  3. #3
    Forum Contributor
    Join Date
    07-22-2009
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    122

    Re: having visablity changes to autoshapes/command buttons after a macro is completed

    Quote Originally Posted by blane245 View Post
    something like this?
    Please Login or Register  to view this content.
    note that the shape that you want to make visible may not be shape #1
    Will this trigger once the macro assigned has completed
    Currently the command button is hidden till a condition is met on the workbook, once you click it launches a macro which displays a message box, then runs the macro, then displays another message box it has completed. I am trying to have the button rehide itself and display autoshape. Would this code go at the end? or in the beggining?

  4. #4
    Forum Contributor
    Join Date
    07-22-2009
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    122

    Re: having visiblity changes to autoshapes/command buttons after a macro is completed

    Thanks for your help, with your code, i was able to figure it out, i was missing a second trigger to rehide the autoshapes when values were reset.

+ 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