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. |
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. |
All times are GMT +1. The time now is 12:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com