Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
MACROS
The last post ( separate lines)helped greatly.
Now how do I save my macros so that they open with all NEW Spreadsheets? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
MACROS
Create an addin.
-- HTH Bob "Kevin" wrote in message ... The last post ( separate lines)helped greatly. Now how do I save my macros so that they open with all NEW Spreadsheets? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
MACROS
hi bob,
I need a little more info then that. I can record and edit macros all day but add ins are new to me. Thanks in advance "Bob Phillips" wrote: Create an addin. -- HTH Bob "Kevin" wrote in message ... The last post ( separate lines)helped greatly. Now how do I save my macros so that they open with all NEW Spreadsheets? . |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
MACROS
Are your macros in a workbook that also has data?
If yes, then Start a new workbook Copy all the macros to this new workbook (inside the VBE) Back to excel and use File|SaveAs and choose addin. Choose a nice name: KevinsUtilities.xla (.xlam if you're using xl2007) Save it to your XLStart folder. But you'll want to make it easy for the user (you???) to access those macros. Saved from a previous post: For additions to the worksheet menu bar, I really like the way John Walkenbach does it in his menumaker workbook: http://j-walk.com/ss/excel/tips/tip53.htm Here's how I do it when I want a toolbar: http://www.contextures.com/xlToolbar02.html (from Debra Dalgleish's site) In xl2007, those toolbars and menu modifications will show up under the addins. And if you use xl2007: If you want to learn about modifying the ribbon, you can start at Ron de Bruin's site: http://www.rondebruin.nl/ribbon.htm http://www.rondebruin.nl/qat.htm -- For macros for all workbooks (saved as an addin) or http://www.rondebruin.nl/2007addin.htm And Bob Phillips shows a way to use a wrapper so that it can work in both xl2003 and xl2007. http://msmvps.com/blogs/xldynamic/ar...me-simple.aspx Kevin wrote: hi bob, I need a little more info then that. I can record and edit macros all day but add ins are new to me. Thanks in advance "Bob Phillips" wrote: Create an addin. -- HTH Bob "Kevin" wrote in message ... The last post ( separate lines)helped greatly. Now how do I save my macros so that they open with all NEW Spreadsheets? . -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
MACROS
Do you know, that was exactly my thoughts when I saw your post.
-- HTH Bob "Kevin" wrote in message ... hi bob, I need a little more info then that. I can record and edit macros all day but add ins are new to me. Thanks in advance "Bob Phillips" wrote: Create an addin. -- HTH Bob "Kevin" wrote in message ... The last post ( separate lines)helped greatly. Now how do I save my macros so that they open with all NEW Spreadsheets? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros: can you copy macros from one doc to another? | Excel Discussion (Misc queries) | |||
Excel 2007 macros - how to merge 5 macros together into one | Excel Discussion (Misc queries) | |||
Macros warning always shows up, even if all macros removed | Excel Discussion (Misc queries) | |||
Macros - copying macros from one computer to another | Excel Discussion (Misc queries) | |||
Training: More on how to use macros in Excel: Recording Macros | Excel Worksheet Functions |