Hello all,
I have an excel file that is a collection of checklists as well as a summary page on the first tab. Each checklist is written in it's own worksheet tab. I want to put a command button on each checklist that, once clicked, will put the name of the checklist on a "list of open checklists" on the summary page. Each checklist has its title written in its respective cell A2. I want that name put in the summary page's cell A10 when the button is clicked.
Also, it is possible to have multiple checklists open simultaneously so if you open a checklist I would like the vba to check if there is text in Summary A9, if there is, then go down another cell until I finds a blank, and then add it to the list of open checklists. Lastly, I would like a command button to close a checklist which would delete it from the list on the Summary sheet.
Thanks!
AJ
I have an excel file that is a collection of checklists as well as a summary page on the first tab. Each checklist is written in it's own worksheet tab. I want to put a command button on each checklist that, once clicked, will put the name of the checklist on a "list of open checklists" on the summary page. Each checklist has its title written in its respective cell A2. I want that name put in the summary page's cell A10 when the button is clicked.
Also, it is possible to have multiple checklists open simultaneously so if you open a checklist I would like the vba to check if there is text in Summary A9, if there is, then go down another cell until I finds a blank, and then add it to the list of open checklists. Lastly, I would like a command button to close a checklist which would delete it from the list on the Summary sheet.
Thanks!
AJ
