Forum Discussion
Solved
VBA Code - Open Workbook Button Hidden
Hello, TIA! I'm stumped, I'm trying to revive a macro book after the creator left the company. The workbook has an expiration code attached to it and when I extend the dates, the macro doesn't u...
Insert the following line below Private Sub Workbook_Open():
Sheets("Instructions").Shapes("menuButton").Visible = True
Did you edit the dates in Workbook_Open to future dates, then immediately save the workbook?
HansVogelaar yes, I have. Which then doesn’t bring up the prompt, so I believe that works.
But the code should make a button visible if it’s not “expired” but it is not. This is my hang up I believe.
Insert the following line below Private Sub Workbook_Open():
Sheets("Instructions").Shapes("menuButton").Visible = True
- That did it! Thank you so much!
