editor

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

I cannot get this line of code to run aDataCalcs(r, 19) = Sheets(DataCalcsnew).Range("T3").Value & " - " & Sheets(DataCalcsnew).Range("Z3").Value I am not seeing any error messages in the vba editor. What can I do to fix this?

I have loaded Excel for the nth time today and I cannot now access the VB Editor. I have the Excel and VB tabs visible. Mouse depress on the VB tab causes the active cell highlighted border to disappear and reappear when mouse released. Trust Settings are fine. I can create macros but not...

I created a xlsm file that created like 10 reports automatically. I go to open the file and it says "Can't find project or library." All the code is gone. I can't save the file as a new file. Basically I can't do anything. I tried to go into the vb editor but it won't let me. I'm numb. numb...

Hello All, This is one of those annoyances that just pops up from time to time and I can find nothing on it anywhere. i work with a dual monitor setup. Often it is better to drag the vba editor from one monitor to the other. Every time i so, it now resizes the editor to the size of a very...

Hi Guys, I just discovered the "query" section under data and would like to use it to get averages of values across multiple excel files in a certain folder. Im trying to start simple, just one file in the folder and bringing in what is called "Table9" into the editor. The problem in all my...

I use Atom as my primary code editor/viewer for all of my scripting and html coding needs. I really enjoy the interface and several of the features in offers. Is it possible to use it as a VB editor for excel?

In my General Settings, I have Enhanced Interface - Full WYSIWYG Editing selected. When I create a new post, it looks like the enhanced editor is active. But when I reply to a post, it looks like it is not until I click on Go Advanced. Is there a way to make it always use the Enhanced Editor?

Hi, I have the next code that run well after I click on play button in VB editor. I need that this code will run automatically after I opened my file.. I tried to copy it to "thisworkbook" tab at VB editor but Im getting repeated error that something is wrong. What I miss here? My code...

I created a new macro the other day and it was working fine. Today when I attempted to open it, i received the error "Can't find project or library" immediately when opening the sheet. I found the support on the microsoft website indicating to: Open your database. Press ALT+F11 to switch to...

Hello, I have the following website: http://greyhoundbet.racingpost.com/#dog/race_id=1596517&r_date=2018-03-15&dog_id=508369 Which I then can get just the block details by using the following URL...

Hi all I am having a 'senior moment' here - in the past I have been able to rename forms in my vb editor, but have totally forgotten how and I can't find a simple way of doing it. Can somenone please remind me how its done? Thanks.

- If I open a .xlam file, I can modify it and save it without a problem (from VB Editor window and File-Save) - But if I have a regular .xlsx opened too, and go to the VB Editor, the File-Save does not save my .xlam file. If I try (or simply clicking on the save icon) the screen flashes but...

Code is ... Sub TENREPEAT() WAITME.Show ("WAITME" is a userform with a picture) For i = 1 To 10 Call RandomNumbers Next i WAITME.Hide --------------------------------------- code is running in the background but Userform not showing Picture until I activate VBA Editor Please...

Apologies if something similar to this has been answered before. At my work there is an excel file that we use most days that when it is opened automatically opens another workbook. However when I look at the VBA for the ThisWookbook object in VBA editor there is no code at all let alone...

I have a spreadsheet with lots of VBA in it that I've used for a number of years. Recently it produces an error message when I open it - Compile error- Automation error. When I ok it, the VBA editor opens with this line highlighted in blue: "Dim workbook1 as workbook" (Dim is not highlighted)...

VBA code can be protected with a password (although it can be hacked using third party software). Regardless, adding a password does NOT prevent access to the vb editor. My workbook contains very hidden worksheets, so the only way to unhide them is using code. But even if the code is password...

Hello, Has anyone used this and managed to get it working: GitHub - gallaux/VBEThemeColorEditor: The VBA / VB editor (or VBE) is limited in the 16 colors it can use to render code text. This application replaces the default colors with custom palettes that can be saved and loaded. It is...

When I run macro VB Editor says "Out of Memory". But when I restarted the file it worked. I Use Window 7, And MSOffice 2007. How to Fix this. Thanks in Advance.

It is possible to prevent users from seeing the VBA by adding a password (admittedly though it can be easily cracked). However, is it possible to prevent users from opening the VB Editor at all? The reason is my program has events but supposing for argument sake, the user opens the VB Editor...