Yep Brett, that's part of the equation.
No floppy.
Users have no network folder.
No printer, or if they must, have BeforePrint make an entry in a logfile.
As to ensuring macro use. I suggest setting up the file to hide all sheets, except a blank sheet. Hide upon close, hide upon save.
Workbook_Open will unhide the sheets, but only if the macro enabled. Oh, if you are really obsessive, have the macro check for username, computer name against a file kept on a network share.
_________________
This message was edited by stevebausch on 2002-10-21 21:15