我的excel 2010，有些文件突然就开不到
之前都用的好好
都有macro的 因为每天要自动截取一些资料
这几天突然频频crash
让我很懊恼下。。 safemode模式下能够开启
可是我的comment都不见了
上了网络找下
找到以下方案
以下解决方案截取于
http://www.ozgrid.com/forum/showthread.php?t=179860
- Go to the Developer Tab and click “Macro Security”.
- Click the dot entitled “Disable all macros with notification”
- Go to Trusted Locations (on the left) and temporarily click “Disable all Trusted Locations”
- Go to Trusted Documents and temporarily click “Disable all Trusted Documents”
- Click Ok and now open “Allocations” or whatever file was not working
- Do not click “Enable Macros”…instead go to the Developer Tab and open Visual Basic
- On Visual Basic, click save and then click Debug > Compile VBAProject
Save in VB and Save in the Excel spreadsheet & then close the file
- Open it and Enable Macros. Should work now.
