Hey everyone, a bit stumped here.
I have a workbook beforeprint sub to load a form that contains a listbox with all the worksheets in the workbook and the user then selects the sheets they want and clicks the print button on the form and the sheets print with the date and sheetname in the header. However I am not sure how to determine which items were selected in the listbox to print.
I deleted what I had tried, but with pseudo code it was similar to this:
for x to totalsheets
if lstsheets.selected(x) then
worksheet.header=date & sheetname
worksheet.print
end if
next
Could someone help me out with this? It would be much appreciated!
Bookmarks