terrypin Posted September 22, 2013 Report Share Posted September 22, 2013 Years ago I learnt some basic VBA coding and wrote many macros for my Excel 2000 (and a few for Word 2000). So when I open Excel files I usually get this message: and I click the Enable button or type 'e' to proceed. I work with the above spreadsheet very frequently so I thought I'd take a few minutes to eliminate that step with a hotkey macro that opens the XLS file, waits for the message and then types 'e'. But Excel obstinately refuses to accept it. I can manually type 'e' at that point, but Text Type (Simulate Keystrokes): e fails. And Tab+Enter. And a mouse click on the button. Do you reckon it's because ME Pro gets 'outranked' by VBA at this stage, or something along those lines, rendering Excel impervious to anything other than manual entry? When I get time I'll see if I can fumble up a a solution with Autohotkey instead. Of course, I can change Excel's Security setting from Medium to Low, which prevents the message appearing, but that then applies to all files. --Terry, East Grinstead, UK Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.