Mar 18, 2015 · I accidentally moved the Locals window in my VBA Editor and now I can't get it to dock back again. I have already tried renaming the registry key then close & reopen Excel to reset the settings (the key I renamed was HKEY_CURRENT_USER\Software\Microsoft\VBA\7.0\Common\) but while some of the VBA settings reset, the window positions did not.

Jan 17, 2018 · Join Date 06-25-2011 Location Sydney MS-Off Ver Excel 2016 Posts 615

Aug 8, 2017 · I have a spreadsheet with VB code. The code works OK when the spreadsheet is open. However if I save and close the spreadsheet, then re-open it I get a pop-up saying just 'Automation Error' plus OK and help buttons. 532265 Clicking on OK opens the VB editor window, the spreeadsheet is locked and the visual basic is stopped.

Jun 27, 2021 · Join Date 08-10-2013 Location Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England) MS-Off Ver

Aug 24, 2023 · The file was created in Excel 2013 and we upgraded to Excel 365. It was a 32bit file. Our corporate IT gave this comment, not sure what they mean about 32-bit libraries are not compatible, how do I switch to 64-bit library? "Furthermore, 32-bit libraries are not compatible so 64-bit libraries should now be used.

Feb 13, 2016 · I was doing some work tonight and went to hit Alt,+ to do an auto sum, but pressed Alt+F11 instead. That opened the Miscrosoft Visual Basic editor. Now, any time I open or close Excel, it opens up and pops up saying "Compile error". How do I stop it from popping up every time? I've tried restarting my laptop many many times, but it just keeps ...

Oct 17, 2005 · When I recorded the macro, I had entered an input range, so I examined the macro code. I didn't see my input range in the code, but I realised I didn't know how the Fourier Analysis application had to be called from Visual Basic anyway. …

Jun 24, 2013 · Join Date 12-15-2009 Location Herndon, VA MS-Off Ver Excel 2010 Posts 163

Dec 2, 2013 · By daddyg_76266 in forum Excel Programming / VBA / Macros Replies: 25 Last Post: 05-03-2015, 09:44 PM ...

Aug 28, 2023 · Microsoft Excel May be able to save the file by removing or repairing some features. To make the repairs in a new file, click Continue. To cancel saving the file, click Cancel. when i click continue, the following message: Excel encountered errors during save. However Excel was able to minimally save your file to 'FILE PATH & NAME'