Templates

Dear Keith

Thank you for attending Excel Courses!! I hope you enjoyed the courses and benefited from them.

I am not sure if you want see a dialog box with a drop down arrow where you can choose the various templates that you may have created or do you want to know if you have a workbook which has Data validation on certain cells with drop down arrows and you want o save that as a template file?

If your query is related to the first part of my question then I am sure you can create a VBA code which will allow you to choose you desired template from a dialog box with drop down list.

If the question is related to the second part of my question then you simply set the cells as drop down lists using the data validation feature and then save the file as a template in the save As Dialog box.

If you want to know more about the course content and the schedule for our VBA course then please refer to the following link.

https://www.stl-training.co.uk/excel-course-in-london-2003-vba.php

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT