I was always under the impression that holding down the
SHIFT key while opening a workbook disabled the automatic
processing of the Auto_Open Macro. Are there other
settings that would cause this functionalilty not to occur
that I am not aware of with office 2000? Suddenly my
project ALWAYS executes the Auto_Open macro even while
holding down the SHIFT key.

Thanks,
Tritan

I am not aware of any change of behavior in Excel 2000 with respect to
holding down the shift key suppressing the running of auto_open macros.

Regards,
Tom Ogilvy


"Tritan" wrote in message
...
I was always under the impression that holding down the
SHIFT key while opening a workbook disabled the automatic
processing of the Auto_Open Macro. Are there other
settings that would cause this functionalilty not to occur
that I am not aware of with office 2000? Suddenly my
project ALWAYS executes the Auto_Open macro even while
holding down the SHIFT key.

Thanks,
Tritan

Tom,

I had one of J-walks Addins loaded. When I remove it the
SHIFT now suppresses Auto_Open. How Do XLAs perform this?

Tritan

-----Original Message-----
I am not aware of any change of behavior in Excel 2000
with respect to
holding down the shift key suppressing the running of
auto_open macros.

Regards,
Tom Ogilvy


"Tritan" wrote in message
...
I was always under the impression that holding down the
SHIFT key while opening a workbook disabled the
automatic
processing of the Auto_Open Macro. Are there other
settings that would cause this functionalilty not to
occur
that I am not aware of with office 2000? Suddenly my
project ALWAYS executes the Auto_Open macro even while
holding down the SHIFT key.

Thanks,
Tritan


.

I wouldn't think there would be a way for an Addin to do this - perhaps it
is a bug.

Regards,
Tom Ogilvy


"Tritan" wrote in message
...
Tom,

I had one of J-walks Addins loaded. When I remove it the
SHIFT now suppresses Auto_Open. How Do XLAs perform this?

Tritan

-----Original Message-----
I am not aware of any change of behavior in Excel 2000
with respect to
holding down the shift key suppressing the running of
auto_open macros.

Regards,
Tom Ogilvy


"Tritan" wrote in message
...
I was always under the impression that holding down the
SHIFT key while opening a workbook disabled the
automatic
processing of the Auto_Open Macro. Are there other
settings that would cause this functionalilty not to
occur
that I am not aware of with office 2000? Suddenly my
project ALWAYS executes the Auto_Open macro even while
holding down the SHIFT key.

Thanks,
Tritan


.

I guess one way it could do it is to instantiate Application Level events,
then in the app_WorkbookOpen event, it could close the workbook and reopen
it perhaps - but I doubt John has code like that in his addin.

Regards,
Tom Ogilvy


"Tritan" wrote in message
...
Tom,

I had one of J-walks Addins loaded. When I remove it the
SHIFT now suppresses Auto_Open. How Do XLAs perform this?

Tritan

-----Original Message-----
I am not aware of any change of behavior in Excel 2000
with respect to
holding down the shift key suppressing the running of
auto_open macros.

Regards,
Tom Ogilvy


"Tritan" wrote in message
...
I was always under the impression that holding down the
SHIFT key while opening a workbook disabled the
automatic
processing of the Auto_Open Macro. Are there other
settings that would cause this functionalilty not to
occur
that I am not aware of with office 2000? Suddenly my
project ALWAYS executes the Auto_Open macro even while
holding down the SHIFT key.

Thanks,
Tritan


.