1004 error troubleshooting

[LactoseO.D.'d]

I have a hidden worksheet that copies itself and creates a new worksheet. On the worksheet I have a command button that I have assigned a macro to:

Private Sub CommandButton3_Click()
    Call MacroName
End Sub

However, I have an issue as to where I store the Macro. Though the macro executes, it only does so if the code for it is stored on the worksheet object. This gives a 1004 error because the macro itself references another worksheet. When I put the macro in a module and tried making the macro global, the reference to it on the command button no longer works. How do I fix this?

 

[LactoseO.D.'d]

Yes it is. It shouldn't be a security issue since the only macros most people run are developed in house. Are there serious shenanigans that can happen if you trust access to the vba project object model?

 

[Norie]

Yes there could be security implications.

I don't know exactly what they might be and could depend on your setup.

There's also the hurdle of organisation policy.

You might be able to do something with signed certificates, but why not see if there's some way to do what you want without programming the VBE.