vba editor

I have Office 365 on Windows 8.1. There are no Add-Ins. When I close a certain workbook it still appears in the VBA Editor. Reopening the workbook sometimes produces another instance of the workbook in the VBA editor which also continues to appear in the VBA Editor after closing the workbook...

I have installed several Excel add-ins that I created on my computer. And whenever I open Excel Visual Basic Editor many of the Code Windows that I have closed before exiting the VBA Editor keep popping up each time I open the VBA Editor. It also happens with some of the forms from those...

Help please! I am using Office/Excel 2016. My VBA Editor has got screwed up. The Project Explorer is rammed on top of the Code Window and both are immovable. When trying to view the Properties Window it takes up the whole screen and is immovable. I want to have the original configuration -...

I keep my VBA code in a separate source file. I am using Excel 2016 on Windows 10. I go to the editor and Select All and press Delete to clear the entire editor. I go over to my source code and select all and copy. I go to the VBA editor and try to paste the code into the editor and it freezes...

I have weird problem: in my VBA Editor (this is not the first time!) code is written (in all modules!) as: someVar = array("1","2") Program each code-word Array auto-convert to array. In another workbook, there are propper line as someVar = Array("1","2") I've spend a lot of time to correct the...

Guys / Gals, The VBA Editor typically groups the code by type: - Worksheets - Forms - Modules - Class - Et Cetera. My explorer just lost this grouping and all items are now sorted strictly alphabetically. How can I restore the grouping by type? Thank you, John In Annapolis, MD

SCENARIO: 1. I have written some macros which simplify some repetitive tasks. 2. Other employees in the company would like to use the code for their personal project spreadsheets. 3. These other employees have zero knowledge of VBA GOAL: I want the employees to be able to go to a folder on...

Hi All, I have quite a long Macro which is a little rudimentary. I've been using it for years but have now made some changes to the dates on the sheet to update it ready for this financial year. If I run the macro from within the VBA editor it will execute fine and do everything I need, if I...