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.