I have a macro in a excel workbook which modifies data in personal workbook which is hidden.
Everytime I close the workbooks, a pop up comes out asking to save the personal workbook.
I used a auto_close event in the 'This Workbook' module of personal workbook.
But it doesnt seem to work.
Can this be done?
auto_close oughta be in a normal module or you can use workbook_BeforeClose in ThisWorkbook
you can also make the macro save the personal workbook after it changes the data
Josie
if at first you don't succeed try doing it the way your wife told you to
I think these events dont work. The reason could be personal.xlsb is hidden.
And I am not actually closing personal.xlsb. I am closing my last visble open workbook (Say Book1.xlsx).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks