UserForm help - display list of open workbooks except workbook userform code is in

[kensweep]

Hi all,

Long time lurker first time poster here.

I'd be grateful for some help. I've searched this problem but it's one of those cases where the solutions given don't actually work for me.

I have a userform that lists all the user's open workbooks. I want it to not show the workbook the userform code is in.

The code I've copied is

Please Login or Register  to view this content.

Appreciate the second sub is just to activate the desired workbook.

My findings are the code above lists all open workbooks but this includes the one the code is in which isn't what I want.

Many thanks.

[Kaper]

Please Login or Register  to view this content.

You could also add checking if workbooks.count > 1 - otherwise your list will be empty

[Norie]

Try this.

Please Login or Register  to view this content.

[kensweep]

Perfect that's great, thank you so much both (obviously, both solutions worked)

[kensweep]

Um, I spoke too soon. Although it achieves what I wanted you've broken the original code from activating the workbook selected from the userform's list.

[Norie]

The only thing that has changed is there is one less workbook listed, I can't see how that could 'break' the DoubleClick code.

By the way, that code doesn't check if a workbook is actually selected and if no workbook selected it that would cause an error

[kensweep]

Hi,

My mistake there, please accept my apologies.

I was confused trying to add a way for the list to refresh on demand to account for the user closing and opening other workbooks. I thought just unloading the userform and showing it again would do this, but playing around found this not to be the case and my playing caused a bug. In the end I was able to achieve this with a button linked to this code

Please Login or Register  to view this content.

It seems missing activating ThisWorkbook first caused issues.

Thanks again.

[Norie]

If you used the code I posted then unloading and showing should work just fine for refreshing the listbox.

[kensweep]

Thanks for letting me know Norie.