CODEWITHSUNDEEP
excelvba
Gary's Student
Gary's Student

Reputation: 96753

Getting to the ThisWorkbook Code Area

From the normal Excel window, I can open the VBE and insert a new module by touching the key sequence: ALT+F11, ALTim all without using the mouse.

Is there a way to open the VBE and navigate to the ThisWorkbook code area without using the mouse??

Upvotes: 1

Views: 160

Answers (3)

user4039065
user4039065

Reputation:

If a VBA project does NOT have modules then first Alt+F11 then,

Ctrl+R, Home, End, Enter.

The Object Explorer seems to get to ThisWorkbook code sheet reliably.

  1. F2
  2. Type t·h·i·s·w·o·r·k·b·o·o·k
  3. Enter, Enter.

That relies on the Object Explorer opening with focus on the search criteria which is not always the case.

Upvotes: 1

Roobie Nuby
Roobie Nuby

Reputation: 1439

If the question is about without using a mouse, you could simply do Alt+F11 followed by Control+R to get to the project explorer, where you could locate ThisWorkbook by using the arrow keys.

If you want a repeatable sequence of characters that will always get you there, that is a more difficult problem.

Upvotes: 1

NickSlash
NickSlash

Reputation: 5077

Control+R to jump to the project browser and then the arrow keys to select works for me.

Upvotes: 1

Related Questions