Working with WorkBook Close event and Personal.xlsb files

Please Login or Register  to view this content.

I have noticed that when i have added some VBA to my Personal file, that the above code when run now does not work as it view the Personal file as another workbook.

But if I simply change (<2) to (<3) then other users whoi dod not have a personal file may have other excel workbooks closed on them without wanting.


Is there a simply way around this?

Is there a line i can use to establish if the other WorkBook name is the Personal file?

Hi, coreytroy,

you might take into consideration that there is both a personl.xls and a personal.xlsb available for a user:

Please Login or Register  to view this content.

Ciao,
Holger