View Single Post
  #2   Report Post  
Nick Hodge
 
Posts: n/a
Default 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!