Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
simple question about macros
Hi
I' ve got few macros binded to one excell file. Problem is that i want to make them visible for all other excell sheets on my computer. Is there a way to do this? Maybe there is a directory I must copy my macros into or something else must be done... thanks for any reply Marcin |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
simple question about macros
Create an addin. Here are some articles on it
Building Application Specific Add-Ins http://msdn.microsoft.com/library/de...ificaddins.asp Excel Add-Ins http://msdn.microsoft.com/library/de...xceladdins.asp Add-ins, Templates, Wizards, and Libraries http://msdn.microsoft.com/library/de...slibraries.asp -- HTH RP (remove nothere from the email address if mailing direct) "mati" wrote in message ... Hi I' ve got few macros binded to one excell file. Problem is that i want to make them visible for all other excell sheets on my computer. Is there a way to do this? Maybe there is a directory I must copy my macros into or something else must be done... thanks for any reply Marcin |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
simple question about macros
Marcin
Copy the macros you have to your "Personal.xls" workbook. This file finds itself in the "XLStart" folder. The files in this folder open every time you start Excel, thus making your macros available during your session. (It's usually hidden from view so you don't know it's open). Regards Mohsen |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
simple question about macros
The workbook with the macros should be open in Excel at the same time as the
other workbooks. Excel provides for this by using a workbook named personal.xls. This is located in the xlstart directory and any file placed there is automatically opened by excel when excel opens. It is also hidden (window=Hide). You could also just locate your current workbook in the Excel Start and optionally hide it if you want. In any event, the public macros for any open workbook are visible in Tools=macros=Macro -- Regards, Tom Ogilvy "mati" wrote in message ... Hi I' ve got few macros binded to one excell file. Problem is that i want to make them visible for all other excell sheets on my computer. Is there a way to do this? Maybe there is a directory I must copy my macros into or something else must be done... thanks for any reply Marcin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
simple i am hoping with macros | Excel Discussion (Misc queries) | |||
Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
Learning Macros and ActiveX controls...have a simple question... | Excel Programming | |||
simple question, hopefully a simple answer! | Excel Programming |