Error in Excel 2007 from 2003 version: saving ActiveSheet as prn file

I have a macro that used to work fine in 2003 but in 2007 gives an error on the line:

Please Login or Register  to view this content.

next few lines are

Please Login or Register  to view this content.

Any idea what's causing the problem. This is causing a distruption to work so a fast response would be very much appreciated.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here