PDA

View Full Version : Solved: BIG PROBLEM..created open-shut file by mistake



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..!!!!

Paul_Hossler
12-06-2012, 11:02 AM
1. Don't enable macros when you open the workbook and see if you can fix it

2. If it's in a Trusted location and you don't get a chance to not Enable Macros, you might have to copy it somewhere else



Good luck

Paul

sabhay
12-06-2012, 11:14 AM
Thanks Paul!!!

Problem Solved :friends: