Where is the code saved in a Form Controls Command Button?

[termeric]

Can anyone tell me where the code is saved in a forms controls command button? I'm trying to update a speadsheet someone else made and i cant find the code. i see it run these instructions to delete the command button, but then its doing all sorts of other things too, and thats what i cant find. is there some secret place to hide code?

Sub Update()
'
' Update Macro
'

'
    ActiveWorkbook.RefreshAll
        ActiveSheet.Shapes.Range(Array("Button 1")).Select
    Selection.Delete
End Sub

 

[RoryA]

No. If that is the macro assigned to the button, then that is the only code it is calling. Perhaps there is other event code that responds to the refreshall command.

 

[termeric]

shouldnt that code be somewhere in the code browser though?

 

[RoryA]

Yes it should, unless there is a COM add-in involved. What exactly are these "all sorts of other things"?

 

[termeric]

i don't think there is a COM add-in.

after it runs that bit of code it opens a connectiong with a database and downloads some information and then formats it.