Jonathan Metzger 05/10/2011 04:06 PM
1-2-3 All Releases Windows XP
This is a longshot but you never now...
There is a sub called Namechange located under the workbook Object. (If you open the Script IDE, under Object Drop-down box there is (Gloabls), Lotus123, then the next one named after the workbook, it's in there).
This Namechange sub appears to fire when the workbook is first opened, regardless of whether AutoExecMacrosEnabled setting is on or off, and regardless of what the workbook calculation mode is set to.
This appears to be a security hole, as code you put in there will execute no matter what...
... most of the time.
Most of the time it does, but I have two workbooks where this event is not fired when I open the them. Does anyone know what causes this sub to fire?