Macro Button on Worksheet Not working

[Cyd44]

Hi,

I have placed a Button on a worksheet which is assigned to a macro. The macro content is as follows:-

Please Login or Register  to view this content.

However, when I press the button, the macro does not get the required information. If I then use excel view macro and then run it, it works fine. Am I doing anything wrong here?

[Steffen Thomsen]

Wich kind of button is it? Form control? ActiveX or a shape with an asigned macro?

[Cyd44]

I am using XL 2010 and the button is just a shape which is assigned to Macro 3

[Medpack]

post a sample workbook and we can resolve your issue

[Cyd44]

Guys,

I found my problem. I was selecting a range but had not selected a sheet, hence it obviously did not know where to go to carry out the code!
Sorry for being so dumb, but I am learning