ActiveX CommandButton Macro

[bpix]

Hi all,

I have a command button which should run this code:

Please Login or Register  to view this content.

The code is fine, if I put it into a module and run it, it does exactly what I want.

However, I can't run it from a module as when I click 'go to code' for the button it goes to the sheet and starts a Sub for it.

if I put the code into this Sheet1 Private Sub and then click the button it only runs the message1 and clear parts and not any of the find function (which I know works)

any ideas?

Cheers,

Bryn

[romperstomper]

In a worksheet code module all Range calls that are not preceded with a worksheet object are applied to the sheet containing the code. This I think is causing an error which your code does not report (as it's not a 91 error). Change the code to use proper qualified syntax:

Please Login or Register  to view this content.

and see if that helps.

[bpix]

I removed the OnError to see what was going on (silly me)

and I got rid of a line of code for sheet3 and now it works, thanks!

Bryn