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?

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?

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?