I am sorry if I am repeating a thread here, but I've tried to find something that will help me, and can't.
I have a model which produces a new worksheet each time it is run - and old sheets are hidden from the user.
I need to write some code that will take the names of all spreadsheets and list them in a userform (or similar) so that the user can then click on the ones they wish to delete and press delete (i.e. be able to select more than one if they wish).
I am happy with being able to assign the commands to buttons once sheet names have been selected, but I don't known how to get the names of the sheets in the form in the first place.
Any help? Please feel free to point me in the direction of another thread if I've missed something.
Thanks for your help in advance.
I have a model which produces a new worksheet each time it is run - and old sheets are hidden from the user.
I need to write some code that will take the names of all spreadsheets and list them in a userform (or similar) so that the user can then click on the ones they wish to delete and press delete (i.e. be able to select more than one if they wish).
I am happy with being able to assign the commands to buttons once sheet names have been selected, but I don't known how to get the names of the sheets in the form in the first place.
Any help? Please feel free to point me in the direction of another thread if I've missed something.
Thanks for your help in advance.