| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Oh! I forgot about the SHIFT thing!
Good one, Dave "Dave Peterson" wrote: I've never seen excel behave this way. (I have the analysis toolpak enabled, too.) If you move the code from the thisworkbook module and put it in a general module (and rename it to Auto_Open()), does that fire? === How does that person open the workbook? Is there any shortcut key envolved (either windows or an excel macro shortcut key???). If yes, remove the shift key from the shortcut. Holding the shift key down while opening a workbook will tell excel not to fire the open procedures. "Sheena N via OfficeKB.com" wrote: Hi Thanks for the quick reponse I removed all code from the Workbook_Open event and placed Msgbox "Test" there. If the Analysis Toolpak Add In is selected the Msgbox is not displayed. If the Add In is unselected the Msgbox is displayed. It looks like if the Addins is selected it does'nt even enter the Workbook_Open event. Thanks Sheena -- Message posted via http://www.officekb.com -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Working time and days | Excel Discussion (Misc queries) | |||
| Trace Dependents and Precedents not working | Excel Worksheet Functions | |||
| Drop-down boxes stopped working | Excel Discussion (Misc queries) | |||
| Colour row that you are working on. | Excel Discussion (Misc queries) | |||
| Calculating Working Days | Excel Worksheet Functions | |||
Hybrid Mode
