ActiveX CommandButton Macro

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

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