Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Where to store standard macros
The standard approach to storing standard macros is to put them in the
Personal.xls spreadsheet. I find that this causes a slight problem if I open two instances of Excel. I get told that personal.xls is already in use, and asked whether I want to make a read-only copy. It occurs to me that I can get around this by putting my macros in Book.xlt. On a quick trial, it seems to work. So, before I go down that route, what are the problems with doing that? Thanks Geoff |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Where to store standard macros
Geoff,
For one, every time you make a new workbook, your macros will be in it. HTH, Bernie "GB" wrote in message ... The standard approach to storing standard macros is to put them in the Personal.xls spreadsheet. I find that this causes a slight problem if I open two instances of Excel. I get told that personal.xls is already in use, and asked whether I want to make a read-only copy. It occurs to me that I can get around this by putting my macros in Book.xlt. On a quick trial, it seems to work. So, before I go down that route, what are the problems with doing that? Thanks Geoff |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Where to store standard macros
Your macros will be placed in every workbook you open.
Some would consider that a disadvantage. -- Regards, Tom Ogilvy "GB" wrote in message ... The standard approach to storing standard macros is to put them in the Personal.xls spreadsheet. I find that this causes a slight problem if I open two instances of Excel. I get told that personal.xls is already in use, and asked whether I want to make a read-only copy. It occurs to me that I can get around this by putting my macros in Book.xlt. On a quick trial, it seems to work. So, before I go down that route, what are the problems with doing that? Thanks Geoff |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Where to store standard macros
"Tom Ogilvy" wrote in message ... Your macros will be placed in every workbook you open. Some would consider that a disadvantage. -- Regards, Tom Ogilvy I have thought about it, and I cannot see why that is a disadvantage. Could you kindly enlighten me, please. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Where to store standard macros
You find one macro isn't working as expected or you want to make it more
powerful. You now get to change it in every workbook where you want the change. A suggestion: Make your macro workbook an addin and load the addin through tools = addins. This will avoid the problem with personal.xls and multiple instances. -- Regards, Tom Ogilvy GB wrote in message ... "Tom Ogilvy" wrote in message ... Your macros will be placed in every workbook you open. Some would consider that a disadvantage. -- Regards, Tom Ogilvy I have thought about it, and I cannot see why that is a disadvantage. Could you kindly enlighten me, please. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Store array ??? | Excel Worksheet Functions | |||
2007 store macros under Menue button as in 2003 | Excel Discussion (Misc queries) | |||
How can you replicate macros for buttons on the Standard toolbar? | Excel Discussion (Misc queries) | |||
store inventory sheet(ex:sports equipment store) | Excel Worksheet Functions | |||
Where to store macros? | Excel Discussion (Misc queries) |