sabhay
12-06-2012, 10:43 AM
I have created a project with many linked Userforms & sheets.
After completion I thought that " As soon as application starts 1st userform should be visible so i created the module like that . Then I thought as soon as userform opens worksheet should close & user should see User form only.
For that, in Userform _initialized function by mistake I inserted application.workbook.close.
Now"BIG" problem is that as soon as I open the workbook it closes immediately.
I am not able to assess Developer tab to make any changes.
This file has become open-shut file...!!!!!!!!!!!
(I tried to recover the earlier version of the file but I could not get as it is overwritten)
Please help me in above issue..!!!!
After completion I thought that " As soon as application starts 1st userform should be visible so i created the module like that . Then I thought as soon as userform opens worksheet should close & user should see User form only.
For that, in Userform _initialized function by mistake I inserted application.workbook.close.
Now"BIG" problem is that as soon as I open the workbook it closes immediately.
I am not able to assess Developer tab to make any changes.
This file has become open-shut file...!!!!!!!!!!!
(I tried to recover the earlier version of the file but I could not get as it is overwritten)
Please help me in above issue..!!!!