Or VB, which won't invoke a macro warning.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Harlan Grove wrote:

"Frank Kabel" wrote...

just curious - wouldn't the sendkeys macro only be activated AFTER you
have allowed macros?
Of course using a different Office application or workbook this could
be feasible but opening the first workbook in Excel Sendkeys should
also require the enabling of macros prior to their execution?


If all macros are disabled, then there's only danger from other apps, but I
know of no way to prevent a macro running in Word from affecting Excel via
OLE.