We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Option Explicit Sub PressDown(MyButton As Shape) ' ' PressDown Macro ' With MyButton.ThreeD .BevelTopType = msoBevelSoftRound .BevelTopInset = 12 .BevelTopDepth = 4 End With DoEvents End Sub Sub PressUp(MyButton As Shape) ' ' PressUp Macro ' With MyButton.ThreeD .BevelTopType = msoBevelCircle .BevelTopInset = 6 .BevelTopDepth = 6 End With DoEvents End Sub Sub Test() Dim shpButton As Shape Set shpButton = ActiveSheet.Shapes(Application.Caller) PressDown shpButton MsgBox "Do some code stuff" PressUp shpButton End Sub
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.