When you hold down the shift key and open a file manually, it disables
macros. Apparently it has the same effect when you use a shortcut key that
includes a shift to fire the macro. When the workbook opens, the macro is
halted.

--
Regards,
Tom Ogilvy

"ben.c" wrote in message
...
Yes, Yes, and Yes....it is working without the shift key in the short
cut...
Do you know why the shift key does this ?
Thanks a lot for the answer, I was really disapointed.