button hides

camper12
camper12 used Ask the Experts™
on
Hi,

I am facing a strange issue. After I click on the button and after my vba code runs the button disappears. I have to reopen my excel to make the button appear. What can be the cause?

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2015
Commented:
Hi
At the end of  your code add  try one of them depending on the button you have
Sheets("Sheet1").CommandButtonName.Visible = True
 ActiveSheet.Shapes("Button younumber").Visible = True

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial