Hi all,

i have a slightly complex problem (for me). What I need is to create new excel worksheets named with the content of some cells in a startoff sheet.
Let say there are cells in row 5 and column 5,8,11,14 with values cat,dog,bird,tiger respectively (cells 6,7,9,10,12,13 are empty).
What i need to do is a button that once clicked opens a user forms with checkboxes for the values of the cell in range (row=5 and columns = 5 to 14) (only those with values, not empty cells). The user then needs to be able to make a selection of which names he wants to use and once the selection is made and OK is clicked, excel creats new tabs named with the user selection (eg cat, dog, bird).

Is there any staight forward way to do this? help is greatly appreciated

regards
thomas