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


.

http://support.microsoft.com/?kbid=175223
XL97: Visual Basic Procedure Halts on Workbooks.Open

But that stops macros - kind of the opposite of the stated problem.

Regards,
Tom Ogilvy

Sandy-V wrote in message
...
I posted a semi related question in July 02, subject:
"Add-in startup problem using keyboard shortcuts"

Dave Peterson pointed me to this thread and a comment by
Myrna Larson

http://groups.google.com/groups?
threadm=u7ufks038r9jjaaa3jrt2c3cpilu7rshja%404ax.c om

At the time I blamed an add-in, in hindsight unfairly, in
rather the same way you just have. Since then I have
encountered a range of oddities with Excel and Shift.

Regards,
Sandy

-----Original 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,

The "range of oddities" I've experienced with Excel &
Shift fall into these "opposite" categories:
Detection of shift when shift not pressed
Failure to detect a shift press

I can relate to the OP's initial suspicion of add-in's. I
also found that removing a certain add-in seemed
temporarily to cure the problem. However I doubt that is
the route cause, at least not directly.

Besides use of Shift in shortcuts to macros, as in the MS
KB article you referred to, a contributory cause might be
Windows shortcuts with Shift to xl files.

Regards,
Sandy

PS Above mainly XL97 but on rare intermittent occasions
experienced similar in XL2000


-----Original Message-----
http://support.microsoft.com/?kbid=175223
XL97: Visual Basic Procedure Halts on Workbooks.Open

But that stops macros - kind of the opposite of the
stated problem.

Regards,
Tom Ogilvy

Sandy-V wrote in message
...
I posted a semi related question in July 02, subject:
"Add-in startup problem using keyboard shortcuts"

Dave Peterson pointed me to this thread and a comment by
Myrna Larson

http://groups.google.com/groups?
threadm=u7ufks038r9jjaaa3jrt2c3cpilu7rshja%404ax.c om

At the time I blamed an add-in, in hindsight unfairly,
in
rather the same way you just have. Since then I have
encountered a range of oddities with Excel and Shift.

Regards,
Sandy

-----Original 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
.



.