see ,page on Getting Started with Macros
http://www.mvps.org/dmcritchie/excel/getstarted.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"VJ7777" wrote in message ...
I taught myself Basic and Fortran in past years but VBA is like Sanskrit to
me. I cannot find a starting place. I have two questions:
1. I have a macro which works in one worksheet of a workbook. I tried to
use "save as" to create a template which I could insert in other workbooks
but it won't work because it is looking for a different macro name; I don't
know how to re-name the macro.
2. I have a workbook whereby I want to protect multiple worksheets. After
protecting two worksheets and saving the file I cannjot open it again because
I have exceeded the 4,000 or 3,000 formats. There is a solution at:
http://groups-beta.google.com/group/...9f7cdf3a4b3e04
but I don't know how to get the macro (macros?) implemented.