code window

I have 4 macros in my ribbon, all located in my personal macro workbook. They are no longer running when I click the buttons. I get the error Macro may not be available or all macros may be disabled" I do have my macros enabled. When I open up the IDE I can see my modules under my personal...

Hi All Flummoxed, I am! I can not right click all lines of my code in the code window. For example in the below partial extract (with no code running) I CAN right click the line UsrName = Environ("UserName") and get all the usual options. But if I right click Call...

I have just joined this forum because I was having trouble with the formats for displaying my code in VBA My first problem was not being able to 'dock' windows - shown on this post and solution suggested by Marcelo Branco (thank you) http://www.mrexcel.com/forum/showthread.php?t=607518 Having...

Hello, Yesterday I got some great help with a problem (see http://www.mrexcel.com/forum/showthread.php?t=348357&goto=newpost) and I need some more today, please. I have a sheet with repeated dates for several months and I need to break out data by week and then by certain criteria. I can do 1...

I have a userform with a multiselect listbox the user seraches using a textbox. I am using the following code to do the search. the only problem is that the results appears at the bottom of the list and I want it to appear at the top. Private Sub TextBox1_Change() 'the change event runs...

Is there a way to close all open code windows without closing VBA? Is there a shortcut or a macro to accomplish this goal?