Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling popup boxes
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling popup boxes
"Robert Chapman" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel shld allow for coment boxes w/ formulas 'mini popup sheet' | Excel Worksheet Functions | |||
Data validation boxes, outputting a final number from the boxes | Excel Discussion (Misc queries) | |||
Moving. Want to number boxes and inventory contents of boxes | Charts and Charting in Excel | |||
Popup boxes for dates? | Excel Worksheet Functions | |||
Non-functional Popup Menu Boxes | Charts and Charting in Excel |