The name might vary depending whether you have renamed the project You can protect your code by locking the project for viewing and providing a password (Tools > VBAProject Properties)(Protection tab, 'Lock project for viewing'). This training is available for groups of 4 or more students.You can protect your VBA projects with passwords although your code is not 100% secure.Īdding a password will deter the average user though. Jackie has provided software training for employees of The Coca-Cola Company, Emory University, Novelis, and more. Our courses can be customized to your needs. Need onsite group training? Call 770.498.7333 or email us. Her company also offers Excel 2007, 20: Certification Prep, Basic through Advanced training. She learned to program with Visual Basic over 20 years ago, and has developed the following Advanced-level Excel courses: Jump Start Excel Macros/VBA™, Painless Pivot Tables ™ and Excel’s Best Functions – from A to Z™. Jackie Kiadii is an Information Technology professional with a degree in Computer Information Systems.

To make it easier for students to see my screen, I usually use Verdana 14 pt. A shortcut for accessing the VBE is ALT F11.Ĭhange the font and size.

You can get to it by clicking the Developer tab, then Visual Basic in the Code group.

Fortunately, changing the font is really quick and easy. The default font of Courier 10 is not the easiest on the eyes. When I teach Excel Macros and Visual Basic for Applications (VBA) courses, one of the student complaints is how difficult the Visual Basic Editor (VBE) is to read.

Vb project excel