Hi
TO add be careful using Personal in networks, a good and i mean very good IT dept will quash this personal setup on reboot as this is good practice so you loose you work, if thisis not the case then good for this question but draaw into question the network, ok ill be shot for that but that the DIR and location nasty programmers use, remove this and threat gone,
I would check the IT dept defaults that the administrate, and if Excel is corperate network edition (which it should be!) then this will happen. If local access ????? not so good bit will allow this function,
So a fix needed i feel....
The most professional way is to export scripts into default file extentions in the dos atributiry thats ti say -/bas files, these are friendly as apposed to cls and vbs files of cause, can email bas with ease not vbs and cls or exe and com for the VB boys out there, if the security if up to scratch of cause.
Not export and remane to recall the macro, inport into new wkbooks as needed.
This is long winded but totally secure and most of all your IT dept wont pester you.
thisis the ideas behind novel and nt platfroms and sign ins repair custom build to company set defaults, a pain but sadlt thats teh world we live in NASTY... thanks to a few..