Microsoft Office Questions? Ask a IT Expert for Support ASAP
Hello. My name is***** will be providing an answer to your question today
Thank you very much for giving us an opportunity to help you. Yes I have see this before can you test this
and see if it help please
In the VBE Editor in Excel, click on Tools > Options > General tab and click to uncheck “Compile on Demand”.
Waiting your feedback
Thanks for this feedback
Ok lets changes the registry key:
HKEY_CURRENT_USER\Software\Microsoft\VBA\7.0\CommonType: DWORDName: CompileOnDemandValue: 0
Waiting your feedback when done reboot before you test it please
Yes you will have problem to do this remotely. Lets install this security update and see if it fix your problem
Thanks yes we can what time ???
Here's a work-around I use if you need to work on a file in the meantime
1) Always have Macros disabled with notification. If you don't then Excel will crash on opening the file because it will encounter the error directly.
2) With macros disabled the file should open and ask you to enable macros. If you click on "Enable Content" Excel will crash. Instead go to the "developer" tab then click on "Visual Basic" on the ribbon. On the left "Project Navigator" window scroll down until you see "Modules". Right Click on "Modules" and select "Insert" -> "Module". This will insert a blank module. I think this resets the VB as uncompelled.
3) Save the workbook and re-open. You can then click on "Enable Macros" and Excel will not crash.
4) Before you save a file that tends to crash, insert a blank module. You can always delete them later.
Okay just send me a messes here if you online and I will log on
Sorry can we make it around 11AM EST time
Hello Again, Please let me know when you online.
Hello please note I waiting for you to fix this problem for you
If this solution worked for you then please don't forget to rate my answer so I am paid for my time
Please, Rate if you are SATISFIED with my help, as this is the only way the site will give me credit for my time. If you still need help, ASK FOR MORE HELP by replying to me.
Hello hope you well, Please let me know if you need more help on this problem or have the solution fix you problem . Waiting for your feedback