Solved: Wrote a Macro in Word, now What???

[mdmackillop]

Hi Julie,
An updated version to try. (I'll test it on 97 later) The output need some formatting, but I think all the fields are functioning correctly. The Calculate function is automatic on the Userform, trigerred when a change is made.

Tony,
I was having some problem (still) with the image, so cancelled the Activate macro. Things still seemed to work as regards opening without the background, so I deleted this and dependent subs, and also the image. I've left in all the declarations and things, as I'm not really sure what's going on!
If you could remove any extraneous items from the start, I think a version of this would be suitable for a KB item or Add-in.

MD

[JOrzech]

MD - Thanks - looks like you've got it pretty much done. I appreciate that for Julie's sake because I'm going out of town for Illustrator training for a week and wasn't sure when I'd be able to get to it.

As always, great job!

[TonyJollans]

I have removed the definitions related to the code you deleted.

For the record, all that's left is:

a) in the AutoOpen Sub in ThisDocument, a line at the start - Application.Visible = False, and
b) The QueryClose Event handler in UserForm1 with the line - Application.Visible = True

The Form does not have an icon, cannot be minimized and does not appear on the taskbar but it can still be selected via Alt+Tab (showing as a Word icon).

[mdmackillop]

Hi Julie,
Are things working?
MD

[n2mopars]

Everyone,

Thank you so much for all of your invaluable time! It looks good...I should be able to figure out the minor adjustments I want to make. Thanks again!!

Julie