Auto_Open disabling

[Tritan]

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 Ogilvy]

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]

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

 

[Tom Ogilvy]

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

Regards,
Tom Ogilvy

 

[Tom Ogilvy]

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

 

[Tom Ogilvy]

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]

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

 

[Tritan]

I agree, I wouldn't think that would be helpful.

But, when it was removed it worked fine.

Maybe I should send him a note!

Thanks for your thoughts.
Tritan.