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?
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?
something like this?
note that the shape that you want to make visible may not be shape #1Please Login or Register to view this content.
Bob
Click my star if my answer helped you. Mark the thread as [SOLVED] if it has been.
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?
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks