Why does this code not work in excel 2007 ?

Hello,

I created a bunch of documents in excel 2003, now have upgraded to 2007 (to take advantage of the dual core ability), and now all my macro's don't work, despite macro security being turned off.

Here is a sample macro :

Please Login or Register  to view this content.

Any suggestions on why this doesn't work?

Hello spyrule,

I don't know if this will help you with your problem. I don't have Excel 2007, but did find this at the Microsoft site...

All potentially dangerous content is blocked or disabled in the workbook without prompts by default. No security decisions are made when a workbook is opened. For example, documents with macros, ActiveX controls, and data links no longer prompt the user about the possible security concern. These features are disabled. However, users are notified when something is blocked, because the Message Bar appears in the program window. The user can click the bar to take action, including allowing the blocked content if the user’s Group Policy settings allow it. In the past, users had to make this decision before they were able to see the document and with access to little or no information about the spreadsheet.

This was taken from here...
Migration considerations for Excel 2007

Sincerely,
Leith Ross

Hello,

Actually, as long as you set your macro security, you don't run into that problem.

However, I figured out what my real problem was.

The line :

Please Login or Register  to view this content.

Should have had a 5 instead of the 6, since I had changed the layout slightly. Doh!.

ahh well, figured and fixed.

thanks again,

spyrule.

Hello spyrule,

Glad you figured it out and shared your findings.

Thanks,
Leith Ross