Maybe look to run this as a addin or activate the macro sheet via a
shortcut on the toolbar.

This way the user calls the mcro through xl not through the individual
templates

Duncan


---
Message posted from http://www.ExcelForum.com/