Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
macro button in all my workbooks
know the basics of how to make a macro. My question is how can I use a
macro in all of my spreadsheets? I would like it to load up automatically everytime I start excel. My macro is basically sorting columns in a spreadsheet. As of right now, I am opening a .dbf file and doing the sorting manually and it is getting old fast! I would like to be able to open the .dbf file, hit the macro button, and save as a .xls file. I asked this question about a week ago and ther response I got was to look up personal workbook in help. I did but only got answers that did not help me in the least. |
#2
|
|||
|
|||
macro button in all my workbooks
The recommendation to read about the personal.xls file was good advice.
Open one of your dbf files. Once it is on-screen and is the active sheet, record the steps you take BUT BE SURE TO SAVE THE MACRO IN PERSONAL.XLS. When you close Excel, you'll be asked if you want to save the changes to Personal.xls. Respond YES. Now your macro is available everytime you start Excel. "Raza" wrote: know the basics of how to make a macro. My question is how can I use a macro in all of my spreadsheets? I would like it to load up automatically everytime I start excel. My macro is basically sorting columns in a spreadsheet. As of right now, I am opening a .dbf file and doing the sorting manually and it is getting old fast! I would like to be able to open the .dbf file, hit the macro button, and save as a .xls file. I asked this question about a week ago and ther response I got was to look up personal workbook in help. I did but only got answers that did not help me in the least. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create a command button, then assign macro to it in excel | Excel Discussion (Misc queries) | |||
Assigning macro to button | Excel Discussion (Misc queries) | |||
Macro Button | Excel Discussion (Misc queries) | |||
Attaching a macro to a VB button on a form | Excel Worksheet Functions | |||
Assigning a macro to a "button" | Excel Discussion (Misc queries) |