Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macros - any other way around xlstart folder?
I've created a macro to format a data file that is created by a data logging
machine. I want this macro to run (via keyboard shortcut) whenever I open this type of file. Since this macro isn't used that often, it's annoying when personal.xlsb opens every time excel starts. Is there a way around this where personal.xlsb doesn't open, but the macro will still be available no matter what xls file is opened? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
macros - any other way around xlstart folder?
What is your problem when the personal file is open
Normal it is hidden, if not read: You can also create a add-in but this makes no different in speed What to do if your PERSONAL.XLS(B) is visible When you open Excel and you see PERSONAL.XLS(B) in the title bar you can use this to hide it. Excel 97-2003: WindowHide Excel 2007 : On the View tab in the window group choose Hide Then close Excel and say Yes to save the changes to your PERSONAL file. -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "evonasten" wrote in message ... I've created a macro to format a data file that is created by a data logging machine. I want this macro to run (via keyboard shortcut) whenever I open this type of file. Since this macro isn't used that often, it's annoying when personal.xlsb opens every time excel starts. Is there a way around this where personal.xlsb doesn't open, but the macro will still be available no matter what xls file is opened? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
macros - any other way around xlstart folder?
Thanks Ron,
The "hide" worked perfectly! "Ron de Bruin" wrote: What is your problem when the personal file is open Normal it is hidden, if not read: You can also create a add-in but this makes no different in speed What to do if your PERSONAL.XLS(B) is visible When you open Excel and you see PERSONAL.XLS(B) in the title bar you can use this to hide it. Excel 97-2003: WindowHide Excel 2007 : On the View tab in the window group choose Hide Then close Excel and say Yes to save the changes to your PERSONAL file. -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "evonasten" wrote in message ... I've created a macro to format a data file that is created by a data logging machine. I want this macro to run (via keyboard shortcut) whenever I open this type of file. Since this macro isn't used that often, it's annoying when personal.xlsb opens every time excel starts. Is there a way around this where personal.xlsb doesn't open, but the macro will still be available no matter what xls file is opened? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XLStart folder,read only | Excel Discussion (Misc queries) | |||
XLSTART Folder Location | Excel Discussion (Misc queries) | |||
xlstart folder | Excel Programming | |||
Book1.xlt in XLSTART folder | Excel Worksheet Functions | |||
Find the xlstart folder | Excel Programming |