Hi,

My company is trying to organise a consistent standard for
Excel presentation spreadsheets so that they are easily
handled by users with no computer experience.

One of the things required is to avoid any popup boxes.
Which means no 'enable macros?' box and no 'read only?'
box if someone else is already using the file.

The first requirement suggests no Visual Basic *in the
actual files*. Unless there's a way to disable this popup
box?

Disabling the read only popup box should be possible with
VB but then how do you use it without causing the problem
you're trying to fix.

I would guess that it's possible to have an autoloading
macro on startup loaded on each person's machine that
would disable both these types of boxes. Does anyone know
how to do this if it is possible?

Thanks,

Rob