macro for new sheets
 

I 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.

Thanks!

macro for new sheets
 

Raza

Look up personal workbook in help

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Raza" wrote in message
...
I 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.

Thanks!

macro for new sheets
 

I looked up personal workbook in help and didn't get anything.

I wrote "create personal workbook" and the only result was how to sort a list!
I wrote "personal workbook" and I got many other hits that had nothing to do
with what I wanted.

Please help!

"Nick Hodge" wrote:

Raza

Look up personal workbook in help

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Raza" wrote in message
...
I 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.

Thanks!