In Preventing auto_open and Workbook_Open events from running I descibed how to do exactly that. Well, it appears that the methods I gave do not always work with Excel 2007.
A visitor of my website complained he could not prevent his Auto_Open macro from running and during a BeamYourScreen session I took over his desktop and confirmed he was right (of course he was).
The situation where we couldn’t prevent an Excel automacro from running was like this:
– You have set up a trusted folder
– The folder is on a network share
– You’re using the UNC path to that folder.
Since I don’t have a network, I can’t easily test this.
Can anyone confirm whether the shift key trick works in these cases:
– Trusted folder on network (but with an assigned drive letter)
Same as above, but for Office 2010?
Jan Karel Pieterse