
In Windows world it is not a good strategy to assume any specific screen resolution, because in Excel you can't really control the absolute position of items in the screen. Excel is built with the assumption, that it is up to the user to adjust document zoom, windows size and screen resolution. But if you insist, you can control any of these settings through VBA, although some of them might require more privileges (for instance the local policy can deny the user right to adjust the screen resolution) and in general it will require a lot of work from your side.
Macro execution is disabled in Excel by default. There are at least three ways to enable it: a) enable macro execution globally, b) put the worksheet in the "trusted" path (or make the path where the worksheet resides "trusted"), c) by clicking "yes" in the pop-up bar which asks whether run macros from this particular workbook this one time. Because of security concerns, it is by design impossible to alter the macro security policy through VBA. The user must to it himself manually (although I believe you can bypass it through 3-rd party automation tools like AutoIt, but I don't recommend it.)


Excel 2007 Ability to have other access the sheet with same format
Does anyone have a snippet for deleting nodes that are older than 1 day? I would like to run this on cron tasks.
