Most Valuable Professional


View Jan Karel Pieterse's profile on LinkedIn subscribe to rss feed
Subscribe in a reader

Subscribe to our mailing list

* indicates required

File crashes Excel!!

Save my workbook!
The best tool for salvaging problematic workbooks.

Trainings

Excel VBA Masterclass (English)
Excel VBA for Financials (Dutch)

Third party tools

Speed up your file

FastExcel
The best tool to optimise your Excel model!

Repair your file

Stellar Phoenix Excel Repair
Best tool to repair corrupt Excel sheets and objects
Home > English site > Articles > Docking VBE Windows
Deze pagina in het Nederlands

Fixing Docking Of Windows In The VBE

If you're a VBA programmer like me, you're probably picky about your window arrangements in the Visual Basic Editor. Sometimes it messes things up and it can be a challenge to get those windows where you want them.

First of all, you have to choose whether or not you want them to dock at all. Tools, options, Docking enables you to set that for each window separately:

Fig 1, Tools, Options, Docking tab for the VBE.

Suppose your window looks like this:

Fig 2, VBE window. Project explorer above Properties window.

and you want it to look like this:

Fig 3, VBE window. Project explorer below Properties window.

What do you do?

Since a picture says more than a 1000 words and a movie is worth a 1000 pictures, I've recorded my movements while doing these things. Download the movies:

Docking the project explorer window

Docking the watch window

Sometimes, one of the windows disappears completely. This may be caused by a change in screen resolution, but I've heard of inexplicable disappearances too. To fix that, follow these steps:


Comments

All comments about this page:


Comment by: Jan Karel Pieterse (12/7/2006 10:51:42 PM)

Hi Dennis,

You should know: there is no such thing as a stupid question, just silly answers and bad software!

I use <a target="_blank" href="http://www.techsmith.com">Snagit</a> for doing all my screenshots, it can also do screen movies.

 


Comment by: Rickard Olsson (3/5/2007 4:15:33 AM)

Agree I was suprised about the loading time of the video. But when it finally arrived I understood directly what to do. Thanks, I have tried hard for a quarter of an hour without making it. So Google and you helped me. Now I am back on track!

 


Comment by: jim (4/26/2007 11:59:30 AM)

It's official. You're the best. I couldn't find the properties window. Some how it had gotten undocked and it was mostly unseen to the right of my monitor. I minimized the VBE and was able to see a sliver of the properties window. Thanks for the help!!

 


Comment by: Wendy (11/27/2007 12:36:46 PM)

Cool. I did not use the exact method described, but did borrow the ideas of it to get my Immediate and Locals windows back into their docking places! Thanks a lot!

 


Comment by: AN (7/3/2008 9:49:08 AM)

Thank you. I think you saved my sanity.

 


Comment by: donna (12/2/2008 4:03:12 PM)

You ARE the best! I would have never figured out the dockable problem myself for the hidden properties window. I had actually looked under options but would have never related the problem to this. I was about ready to reinstall office. Thank you!

 


Comment by: John (2/16/2009 1:31:29 PM)

Thanks for this post. I searched high and low to figure out how to get my VBA Editor windows back to normal. I've now book marked this page.

 


Comment by: Redman (10/29/2009 6:29:21 PM)

Fantastic page. Lost so much time trying to find the answer to this question. Thanks so much for sharing this with the world. : )

 


Comment by: AK (11/3/2009 6:06:20 AM)

Hi
I undocked and then redocked my properties and project explorer window, now the code window seems to not resize automatically to size according to the window.. that is it still occupies the entire space, and the Project explorer /Properties window floats above the code window.. how can I get it back to normal

 


Comment by: Jan Karel Pieterse (11/3/2009 2:10:10 PM)

Hi AK,

What happens if you doubleclick the titlebar of the code window?
Alternatively, you could select Window, Cascade to have all code windows fit in the blank area next to the project explorer.

 


Comment by: AK (11/5/2009 10:49:29 PM)

Hi Jan,
I got it back to normal by dragging the project explorer to the extreme left of the screen, though now , the properties window doesn't dock with the project explorer and ditto for the immediate window. I even reinstalled MS office but it doesn't work. My company settings do not allow me to do a RegEdit.. there has got to be a simple way of doing this

 


Comment by: Jan Karel Pieterse (11/5/2009 11:18:46 PM)

Hi AK,

Are their dock settings checked?

 


Comment by: Tony (11/24/2009 7:22:01 PM)

Thank you! This drove me crazy until I found your page.

 


Comment by: Bjorn Brechan (2/23/2010 5:40:23 AM)

No matter what I do of the above suggestions, the Project explorer window and the properties window will only dock horizontally at the bottom or top. And yes, it seems like a very silly question - but it is anoying not to have an overview like one used to have....

Please help!

Regards
Bjorn

 


Comment by: Jan Karel Pieterse (2/23/2010 8:36:39 AM)

Hi Bjorn,

Doesn't the video help?

 


Comment by: Garry (5/21/2010 5:14:59 PM)

I was frustrated so much that I couldn't dock back to where they were. Thank you very much!! Now, I know how to put them anywhere I want them. And, your movies help a lot, too.

 


Comment by: Jana (8/18/2010 3:59:36 PM)

You have NO idea how long I have been terrified to rearrange my docking for fear I'd undock everything and never get it back.

You've done a fantastic job explaining, and the video got me over the minor hump of docking windows horizontally.

Thanks muchly!

 


Comment by: Kyle (10/1/2010 6:37:17 PM)

Man, that took a long time for me to get that back. Your video helped so much. Microsoft's "help" is insufficient, but you have saved me hours. Thanks!

 


Comment by: NT (10/15/2010 1:48:22 PM)

Thanks Thanks Thanks

 


Comment by: Hervé Thiriez (12/27/2010 2:11:01 PM)

To Bjorn,

The trick is that, if you want to anchor the windows on the left, you must first reduce the VBE window. Otherwise, you cannot drag a window which is inside the VBE editor enough on the left (i.e. 50% outside of the VBE window) that you can see the thin line - which replaces the thick outline - with which you may relocate and anchor the active window.

 


Comment by: Chris (2/16/2011 3:11:58 AM)

Thanks very much for this info.
I couldn't rename a module but using your trick of Options/Docking and undocking the Properties window I was able to rename the module in the floating Properties window. However, when I set the docling option back to docked the Properties window disappears again.
I am using Office 2002. I have MZ Tools installed so I don't know if that is significant. I don't program Excel much these days, I'm an Access nut so I don't how long I've had this problem.
Any ideas why the Properties still disappears??
Again, many thanks for the work-around.

 


Comment by: Jan Karel Pieterse (2/16/2011 4:33:46 AM)

Hi Chris,

To get a window back which is not docked, make sure the dock checkbox for that window is unchecked.
Then close all module windows (to avoid clutter).
FInally, select Window, Tile Horizontally (or Vertically). The windows should now all be available for resizing and repositioning.

 


Comment by: Chris (2/16/2011 4:50:31 AM)

Yes, this is what I did the first time around but I prefer to have it docked because I always work with the module pane maximised. So with a floating Properties window it fills the module pane. If I dock it, it disappears again.
It sounds like I'm stuck with it undocked.
Thanks for your time and efforts.

 


Comment by: Jan Karel Pieterse (2/16/2011 5:48:03 AM)

Hi Chris,

Are you sure the window isn't there, maybe it just has a very small width or height? After setting it to dock again, check the edges of your VBE screen, maybe there is a very narrow or very short window stashed away in a corner?

 


Comment by: Chris (2/16/2011 6:33:30 AM)

You're a genius!!!!!

The left edge looked just like a frame but in fact was my Properties window.
Thank you, thank you, thank you :o)
This was driving me nuts because I teach this stuff so I'm expected to be the expert but I couldn't solve my own problem. We all learn a little every day.
Well done, that's great.

 


Comment by: Hilfy (3/15/2011 1:05:43 PM)

Thank you so much for that helpful information!

 


Comment by: John (8/9/2011 3:27:28 PM)

I change the docking, and set the windows just the way I want them. But Access does not remember my settings and changes them all back when I close and reopen my database. How do I get Access to remember my last settings and keep them?

 


Comment by: R L Jeffcoat (8/17/2011 10:52:38 AM)

Thanks for a clear explanation of a useful but poorly documented feature. This is a very helpful site!

 


Comment by: Jan Karel Pieterse (8/22/2011 2:42:32 AM)

Hi John,

I'm afraid I wouldn't know how Access handles this!

 


Comment by: mesh (9/2/2011 3:56:51 PM)

how do you prevent the Microsoft Excel Objects menu opening up all the time? it's very annoying

 


Comment by: Jan Karel Pieterse (9/4/2011 11:01:01 PM)

Hi Mesh,

Not sure what you are referring to. Do you mean the Object browser in the VBA editor?

 


Comment by: mesh (9/5/2011 2:53:50 AM)

Thanks Jan,

not the object browser, the project explorer windows on the left hand side, the one with cascading folders:
+ VBAProject(filename.xlsm)
+ Microsoft Excel Objects
    + Sheet1
    + ...etc
+ Forms
+ Modules
+ Class Modules

the first menu opens whenever you browse away from the VBA Editor and so if you have more than a few sheets you have to scroll down all the time.

 


Comment by: Jan Karel Pieterse (9/5/2011 2:59:18 AM)

Hi Mesh,

A workbook's VBA project opens in the state it was in when you saved the workbook. To ensure a workbook opens in collapsed state in the project explorer, you must close all code windows, then collaps the project and then save the file. Another way is to set a password on the VBProject.

 


Comment by: Paul (9/23/2011 9:57:08 AM)

Big Thanks.

My VBA windows docking got screwed up and I just couldn't resolve it until I read your article!!!!

 


Comment by: Geoff Morris (10/25/2011 6:43:28 AM)

Thanks.

Even following your instructions it took me a good ten minutes to force the damned things back into their proper docking positions! The project pane kept insisting on filling the window width or the project and properties panes would both become ten characters thick and stuck side-by-side etc. There's really something wrong with the way this "works"...

Anyway, I came here because I am one of those who had an inexplicable screw-up to start with... in my case, the main menu and toolbars simply disappeared! While trying to fix this I accidently closed the projects pane and then all hell broke loose... (The menu and toolbars came back when I closed and re-opened the editor.)

 


Comment by: David (2/28/2012 4:28:44 PM)

Must agree with so many others.

A feature that's great to use, but so easily destroyed.

Then you/I forget how to get it back

 


Comment by: David Byrne (2/28/2012 4:32:22 PM)

Hi,

Have worked just in Excel/VBA since Quattro-Pro days.

Have recently solved issues of graphics transfer that failed in 2010/2007 with 2003 code.

More details if required/interested.

Loss of Pull-Down menus one of biggest failings of post 2003 versions!!

Regards

David

 


Comment by: philxt (3/6/2012 1:50:50 PM)

many thanks - being trying for weeks to get my default VBA windows back, all previous suggestions no use at all. You're explanation help me sort the problem but more importantly helped me understand how to change the windows in future

 


Comment by: Justin (3/25/2012 10:56:30 PM)

Thanks for the guide, it was killing me trying to get the view back in order. You got me in the right direction very quick.

Thanks for taking the time.

JD

 


Comment by: Jam C (6/13/2012 10:48:45 AM)

Hi Jan. I use VBA via iFix, rather than an Office application. Annoyingly it does not retain workspace settings on closing. On servers with Office you can get round this by setting up your workspace in Office VBA first, and then iFix will use it. But on the server we mainly develop on there is no Office installed so every day it's:
1.     add the Edit toolbar
2.     drag it up to dock with the other toolbars
3.     dock the Properties window on the right and
4.     resize the Project Explorer window,
which all gets a bit tedious.

I've tried tinkering in the Registry as it appears the settings are saved there by Office, but it's a bit hit and miss, as I can't tell which key to alter.

 


Comment by: Jan Karel Pieterse (6/13/2012 11:52:05 AM)

Hi Jam,

I expect the settings for the VBE are found here:

HKEY_CURRENT_USER\Software\Microsoft\VBA\6.0\Common
(Excel up to 2007)

or here:

HKEY_CURRENT_USER\Software\Microsoft\VBA\7.0\Common
(Excel 2010 and up)

You could try exporting that part of the registry from a system with the settings you like and then importing that reg file in the iFix environment.

 


Comment by: Jam C (6/13/2012 4:07:52 PM)

Thanks Jan, I exported that key from a server with Office and imported into my own HKEY_USERS id equivalent path (so as not affect anyone else on the server), and it did the trick.

In your face, GEFanuc, company behind iFix, who's support team told me it couldn't be done!

Now to get on with my life...

 


Comment by: Jan Karel Pieterse (6/13/2012 4:17:30 PM)

Hi Jam,

Could you perhaps point GEFanuc to this page?

 


Comment by: Dennis (6/17/2012 4:41:55 PM)

Perfect....A real help

 


Comment by: Les (8/6/2012 6:17:10 PM)

YOU ARE AWESOME!
I've been coding in Excel VBA for 15 years and a few times over the years I have accidentally changed my Immediate and locals windows. I've never found a method to correct and until now just had to live with it...but no more...

 


Comment by: Nigel (8/16/2012 10:49:45 AM)

Fabulous!

I too have been using VBA for many years and have struggled to re-dock the properties window in particular on several frustrating occasions!

Warm thanks

Nigel

 


Comment by: Eve (8/27/2012 11:20:08 PM)

Thanks, Helps so much to make one feel comfortable

 


Comment by: Lisa Green (11/8/2012 4:21:39 PM)

Hi,

I have a userform open in the VBE.
There is a button to toggle resizing to three different sizes.. Min/Max/Run where Run is a portion of the userform.
When the user clicks the button I'd like the top left of the userform to stay where it is but can't seem to get it to do that :-(

Canyou help please? Remember the userform is in the VBE.

Hugs
Lisa

 


Comment by: Bob F. (12/14/2012 7:59:42 AM)

Thank you for the videos! I had been trying ti figure out how to dock my immediate and locals window side by side on the bottom for ages. Cheers!

 


Comment by: Jean Paget (8/26/2013 10:12:57 AM)

Wow! THANK YOU, thank you, thank you! It took some doing but finally found the position to dock it. Would never have achieved this without watching the video.

 


Comment by: Edward Cross (9/2/2013 6:18:56 PM)

When I dock the VBA Project and Properties windows they always fill the full width of the VBA Editor Window leaving only a small height for anything else. Before making these windows dockable they are of any width that I choose to make them. How do I get them stay less than full width or how can I adjust the width as necessary after docking them?

 


Comment by: Edward Cross (9/2/2013 7:42:49 PM)

I spent some more time with it and found that I could click and hold at the right side of a window, Project or Properties, which extended across the full width of the VBA page and pull the windows into smaller, narrower windows and move a window down to dock it below the other.

Thanks.

Ed

 


Comment by: Jan Karel Pieterse (9/3/2013 10:26:15 AM)

Hi Edward,

Glad you got it solved!

 


Comment by: Jean (9/17/2013 7:58:26 PM)

THANK YOU SO MUCH!!!!

I followed the instructions but could not get it to work, then I followed the video and realised I had to go way down further that I would have expected - like you said, a picture paints a thousand words!

 


Comment by: jaime (9/25/2013 12:11:06 AM)

Your explanation and the video were very clear and simple. Together they were great great help.

 


Comment by: michele (10/2/2013 7:26:57 PM)

THANK YOU!!!!!

 


Comment by: Gary (12/18/2013 9:39:07 PM)

This doesn't help me - my project window covers entire upper half of the screen, all the other windows are across the screen below that horizontally. I am trying to get back to the views being vertical as they are shown above

 


Comment by: Jan Karel Pieterse (12/19/2013 9:40:28 AM)

Hi Gary,

Check out the docking settings in tools, options and comapre them to the ones I set in the article, are they set the same?

 


Comment by: Rusty (3/8/2014 6:39:10 PM)

Hi.
As your pictures show I got the Project and Properties windows on the left side fixed (docked) but as soon as I open the area to write my code (the dark grey area in pictures) the sheet to put the code in, it comes up as a retangular window across the whole are, then I have to keep resizing it to fit into that dark grey area.

What am I doing wrong

Rusty

 


Comment by: Jan Karel Pieterse (3/8/2014 7:00:06 PM)

Hi Rusty,

Can't you simply maximise the code window?

 


Comment by: Rusty (3/9/2014 8:19:09 AM)

Hi Jan.
Yes I can do but that fills the full screen and I like to have the Project and Properties on the left side all the time as it was previously before something went wrong and Im sitting with the problem I have. It becomes frustrating to resize the code sheet or other userform sheets all the time. I know it can be fixed if you go into the registry but things can go wrong.
Rusty

 


Comment by: Jan Karel Pieterse (3/9/2014 9:33:39 PM)

Hi Rusty,

I would check the options window again, see if the docking settings are as I show on this page.

 


Comment by: Rusty (3/10/2014 6:52:55 PM)

Hi Jan

I reopened the file with the workbook I'm working on, right clicked the sheet to veiw the code, used the option and docking options unclicked all tics saved the workbook, exited it and reopened clicked the sheet for the code to tic (locking) the docking boxes one by one to see what developes, and low behold the project and properties was on the left side of screen and the code writing area was as it should be. I saved, closed it, reopened and there it was everything as it should be, all working well, no tics in the docking boxes.
Thanks for the help, go well
Rusty

 


Comment by: David (5/15/2014 4:53:27 PM)

Can we dock the ToolBox, as I move around and i have 2 monitors, I keep loosing the Toolbox.
Thanks, David

 


Comment by: Jan Karel Pieterse (5/16/2014 12:37:09 AM)

Hi David,

I don't think you can, at least I couldn't find a way to dock it.

 


Comment by: Bernd (6/7/2014 3:01:00 PM)

Your article did help me up to a point, because now I can at least see the Immediate Window at the same time as the code of the macro. Thank your for this!!

However, no matter what I do, the moment I uncheck the docking for the Immediate Window this window disappears, and it is *not* very small, it really does disappear.

Still desperate (because I now also see all the macros in the workbook and the personal... ) and have to close them one by one, before I can start working.

Bernd

 


Comment by: Jan Karel Pieterse (6/10/2014 8:53:14 AM)

Hi Bernd,

There is a trick to do this using mouse and keyboard. It takes a bit of fiddling.

On any window, hit Alt+space to open the system menu. There should be a move command and it has an underlined letter. In English Windows this is the M. If you press the M and subsequently one of the arrow keys just once, the window in question is put into the move state, at which point you can use your mouse to position it. Drag it to where it is needed and click once with your mouse.
So:
Control+g, alt+space, M, down arrow, drag mouse, click.

 


Comment by: M Davidson (7/14/2014 7:14:03 PM)

THANK YOU!!!

 


Comment by: Greg (10/8/2014 5:53:35 PM)

Thank you. I did something to un-dock my properties window and it wasn't until this piece that I understood what happened and how to fix it. Thanks again.

 


Comment by: Chris (12/17/2014 8:21:41 AM)

Thanks a lot!

 


Comment by: Ginna (1/26/2015 9:11:00 AM)

It took me a couple of tries, but finally worked. Thanks so much! Did you ever imagine that your "tip" written in 2006 would still help people in 2015?

 


Comment by: Jan Karel Pieterse (1/27/2015 7:21:44 AM)

Hi Gina,

Good to hear that! The tip will continue to help people for as long as Microsoft will not update the VBA editor, which I expect is going to be a looooong time :-)

 


Comment by: Sam (2/2/2015 2:43:55 AM)

"Comment by: Jan Karel Pieterse (6/10/2014 8:53:14 AM)
Control+g, alt+space, M, down arrow, drag mouse, click."

Oh my goodness. This worked. You are amazing. I lost my Properties Window months ago and no matter what I searched for, every topic said "Oh, you turned off Docking, turn it back on again."
I found it like 3 inches outside the boundary of my monitor. I would have literally never found it without you!

Thank you again!

 


Comment by: Jan Karel Pieterse (2/2/2015 10:49:03 AM)

Hi Sam,

:-) Glad I was able to help!

 


Comment by: Francisco (2/24/2015 7:42:53 AM)

I was trying to this for since January. Thank you!!!!!

 


Comment by: KRH (3/5/2015 7:24:21 PM)

Genious! Thanks so much :-)

 


Comment by: zvika (3/8/2015 1:33:01 PM)

thanks!!!!!!

 


Comment by: Will (3/19/2015 3:27:03 PM)

brilliant!!

 


Comment by: manny (4/8/2015 2:44:42 PM)

I love you. Same as above. Screwed up my docking and spent 20 minutes looking for an anser till I got here. Thanks! :)

 


Comment by: Jan Karel Pieterse (4/8/2015 3:58:20 PM)

Hi Manny,

:-)

 


Comment by: Jens (5/14/2015 8:52:38 AM)

Hi, just by following some of the questions my sanity has been restored - GREAT!!!

 


Comment by: Genesius (6/1/2015 3:23:58 PM)

Great information.
Do you know if there is a fix for the variables disappearing in the Watch window each time F8 (or F5 with a break) is pressed?
Is this just a bug that MS sees as not a problem?
Thanks in advance and God Bless,
Genesius

 


Comment by: Matt (6/4/2015 2:03:52 AM)

Thank you for the info about docking within the VBE window!

My "OCD" extends beyond that, though; I want to place my VBE in a 50%-pane on the right half of the screen, and put the Excel spreadsheet in a 50%-pane on the left half. With two spreadsheets, you can easily do this with the "View > Arrange All > Vertical". However, this does not set the Excel Spreadsheet and VBE windows side-by-side.

Is there a way that I can easily do this without having to use my trackpad to slowly drag & resize the windows (which is both time consuming and annoying!)?

Thanks!

Matt

 


Comment by: Jan Karel Pieterse (6/4/2015 7:22:33 AM)

Hi Matt,

If you have Windows 7 or up you can hold down the windows key and then press the left arrow to position any window on the left half of the screen. Similarly, use the right arrow key to position a window on the right half. Dragging a window with your mouse also works this way.

 


Comment by: Cunnial (6/15/2015 10:23:08 PM)

Legend... That is all.

 


Comment by: tjf (9/23/2015 4:52:45 AM)

You are a genius!!!!

 


Comment by: Tahir (11/30/2015 1:04:17 AM)

hi there,

how can I move objects i.e. textbox using keyboard arrow keys on form while designing and aligning objects on the form?

thanks.

 


Comment by: Jan Karel Pieterse (11/30/2015 12:06:14 PM)

Hi Tahir,

I don't think you can actually. But there is a nifty tool by Stephen Bullen which enables you to move controls very precisely. it is called VBE Tools and is available through hiw site www.oaltd.co.uk .

 


Comment by: Seb (12/28/2015 2:04:27 AM)

Your comment here:
http://www.excelforum.com/excel-programming-vba-macros/343845-docking-project-explorer-vertically.html

saved me! Thank you!

 


Comment by: Mark W. Stump (1/13/2016 2:44:44 PM)

Thank you Jan Karel :-)

I have come to this page several times when I forget how to unscrew what I accidently drug around. Very handy tips indeed!

Thanks again,

Mark

 


Comment by: Rodolfo Castro (2/26/2016 3:35:46 AM)

When I click on the VB editor I get a page with my macros, no toolbar. If I right click on that page I get a few commands, and very difficult to use. I am using Excel10 and I recently "upgraded" to Windows 10, from Windows7, where I never had any problems like missing VBA toolbars. I am at a total loss. What can I do?

 


Comment by: Jan Karel Pieterse (2/26/2016 2:31:48 PM)

Hi Rodolfo,

If you have access to your registry, you could try this:

- Close ALL VBA Editor windows. Better yet, close all Office applications.
- Open the registry editor (regedit.exe)
- Navigate to this key:

HKEY_CURRENT_USER\Software\Microsoft\VBA\7.0\Common

- Right-click it to export it (select your desktop to make it easy to find it).
- Find an item on the right called "UI" and delete it.
- Open Excel and the VBA editor
- If that fixed things you're done of course. If not, you may consider double-clicking the registry backup file to restore the key.

 


Comment by: Helen Rolls (8/26/2016 1:11:24 AM)

Thanks. Not being able to dock the Immediate Pane after accidentally undocking it has been driving me nuts!

 


Comment by: Chris (11/17/2016 1:12:52 AM)

Ten years on and your advice is still helping out! Many thanks JK!

 


Comment by: saeid (12/4/2016 11:29:25 AM)

THANK YOU For Help!

 


Comment by: Itunu (2/9/2017 5:46:52 AM)

Thanks for this actually. Sometimes you never know how helpful this is.

Great Job.

 


Comment by: Sajith Sudhi (3/13/2017 6:39:42 PM)

you are a life saver. That video really helped me. Thank you so much

Super Job.

 


Comment by: Mandora (4/9/2017 9:56:09 PM)


Even with video help could not get panes to anchor properly in Excel 10 VBA.

Exported HKEY_CURRENT_USER\SOFTWARE\Microsoft\VBA\7.0\Common from another computer and imported into wayward Excel. Problem solved!!

Note: Saved above key to Excel_VBA_Dock_Fixit and saved file for future use.

 


Comment by: Harikiran (6/19/2017 2:05:14 PM)

Hello,

Where can i find resources which can help me start, understand and subsequently code in VBA to automate few processes in outlook and excel.

ThanQ in advance, appreciate the time!

 


Comment by: Jan Karel Pieterse (6/20/2017 10:05:30 AM)

Hi Harikiran,

Not easy to answer. The way people learn is personal. For example, I prefer to learn by trying to do things on real projects rather than some made-up example with no use.
I also prefer to have my information in writing and not in video so you'll never see me watching a youtube video to learn things about Excel or VBA. I'll grab a book and go from there.

 


Comment by: khan (7/8/2017 3:09:39 PM)

Thanks alot man my problem has been solved..Thanksss alot

 


Comment by: Thomas (9/12/2017 11:36:44 AM)

Now I can put my object browser on my third screen, thanks!

 


Comment by: Mompo (12/4/2017 1:24:58 AM)

This is very helpful!!! saves my day!

 


Have a question, comment or suggestion? Then please use this form.

If your question is not directly related to this web page, but rather a more general "How do I do this" Excel question, then I advise you to ask your question here: www.eileenslounge.com.

Please enter your name (required):

Your e-mail address (optional but if you want me to respond it helps!; will not be shown, nor be used to send you unsolicited information):

Your request or comment:

To post VBA code in your comment, use [VB] tags, like this: [VB]Code goes here[/VB].