Ignore personal.xlsb when counting open workbooks

I want to control the way a workbook userform is closed by only quitting the application IF it is the only workbook open. Otherwise it will close the workbook and leave the application open for the remaining workbook.

Please Login or Register  to view this content.

i remembered though that I use a personal.xlsb file which no other user does which distorts the count. I used this to initially list workbooks open BUT I cant seem to get it to ignore the "personal" file so the count is 1 for all users

Please Login or Register  to view this content.

Any Ideas appreciated

Please Login or Register  to view this content.

Hi shg

Im a bit confused LOL - I ran your sub and the workbook count was 2 (I expected it to be open workbook less xlsb file and the "+1" you specified)

however if i remove the "+1"

my workbook count is "0" not "1" as I would expect - any ideas???

Edit Sorted shg - personal workbook name actually personal111 so needed

Please Login or Register  to view this content.

Ill work out how to use the function in the cancel button

Many thanks

You're welcome.