Assigning a new Macro to one document.

[rcbill]

I created a macro for a document that I want to run when the document is opened.

The macro is created and saved and works as desired.

However, I can't figure out how to assign that macro to the Document Open event.

I open the macro editor, select the macro I want to assign and then select the Assign button, but when the Assign dialog is open, it doesn't contain macro located in the document.

This is a document specific macro that I do not want accessable in other documents.

How do I assign this macro when the Assign Event doesn't show it?

Thanks,

Richard..

[JohnV]

From the document (not the macro) do Tools > Customize > Events tab where you will find your macro.

Your problem is a bug.

[rcbill]

Okay, I found that, but when I assigned the macro to the "Open Document" event, closed the document and then opened it, all the macro gave me were numbers.

Should be:
Friday, November 5, 2010 at 8:51 AM

Macro returns:
40487.48 at 40487.48

The macro worked correctly until I attached it to the Open Document event, then it started returning only numbers. Now that is all it returns, even after I removed it from the event, closed and reopend the document, it is still giving just numbers.

What is going on here?

Thanks,[/list]

[JohnV]

Put the date, etc., in the document using fields then select it and make it an AutoText entry (Ctrl+F3). That use to also return numbers but works correctly now.