Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
shortcut to open file in personal.xls blocking file's macros
Hi,
I've looked and could not find it. I have in my personal.xls a shortcut (ex. ctrl+shift +a) which runs a particular excel file. But this file has also vba code in workbook_open sub(). And when I am runing this shortcut to open this file a file is opening but the code in this workbook does not start. Why ? What shal I do to run this code when I am runing this file from this shortcut. When I open this file from menu/open everything works (the workbook_open sub starts). Any idea? Thank very much |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
shortcut to open file in personal.xls blocking file's macros
Shortcuts that include the shiftkey can break the auto_open and workbook_open
macros. Try using a different shortcut that does not include the shift key. wrote: Hi, I've looked and could not find it. I have in my personal.xls a shortcut (ex. ctrl+shift +a) which runs a particular excel file. But this file has also vba code in workbook_open sub(). And when I am runing this shortcut to open this file a file is opening but the code in this workbook does not start. Why ? What shal I do to run this code when I am runing this file from this shortcut. When I open this file from menu/open everything works (the workbook_open sub starts). Any idea? Thank very much -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Button / Shortcut to extranal file's macro? | Excel Discussion (Misc queries) | |||
my file's format changes when i open the file on another computer | Excel Discussion (Misc queries) | |||
macros in personal.xls file | Excel Worksheet Functions | |||
macros in personal.xls file | Excel Worksheet Functions | |||
Desktop shortcut to a named Excel file - every time I open it adds a "1" to the file name - how to disable? | Setting up and Configuration of Excel |