Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

VBA editor page

0

My daugther has managed to alter the opening of the VBA Editor page, when I first opened the Editor Alt+ F11 it opened with the Project - VBAProject page and the Properties Sheet were locked to the left hand side, my daugther borrowed my Laptop and since its return the Project - VBAProject page and the Properties Sheet appear any where they please and in various sizes

Answer
Discuss

Answers

0
Selected Answer

Your super-smart daughter turned off docking for the VB Editor window. To turn it back on go to Tools > Options (from the VBE), select the Docking tab, and checkmark the windows you want docked.

Recommendation:-
While busy on the Options, look at the Editor tab and turn on "Require Variable Declaration". This will cause VBA to add the "Option Explicit" statement at the top of every code sheet you create thereafter. Option Explicit has been mis-sold by MS from the start as a trade-off between extra work and more convenience. This is like washing dishes after dinner. Yes, if you don't mind eating from dirty plates it's a trade-off too.

MS makes you feel like smart people - maybe super-smart people (with a nod from Bill Gates to the younger generation) - don't need Option Explicit. I haven't come across a programmer yet who would want to work without it or a project where it didn't save time.

Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login