Re: A tighter security method.
The use of VBA is perfectly cromulent at low levels, and absolutely evil in situations where 'you should probably be using a proper development platform'. The problem comes when you start with the first, and slowly add stuff until you're in the latter category.
For basic - sorry, unintentional pun - automation of simple Office functionality, there is nothing that even comes close to VBA.