Disabling popup boxes

[Robert Chapman]

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

 

[Keith Willshaw]

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

There's no way to programmatically disable these boxes.
If there were that would represent a massive security
hole of the sort Microsoft are oft criticised for.

In the case of machines used specifically for presentations
you could set the macro security level to low which would
mean that you never saw those boxes, this does of course
leave you open to malicious macros so you should
NOT do this on a machine in normal network use.

Keith