Solved

Worksheet "title bar"

Posted on 2013-11-07
3
237 Views
Last Modified: 2013-11-08
I'm trying to learn VBA and already having problems! /-:

I'm looking for the code for the workbook which, according to the book, I get to by right clicking on the workbook title bar and selection "view code".  

But what I think is the title bar doesn't produce a drop down with that option.

Title Bar
0
Comment
Question by:mikecox_
3 Comments
 
LVL 18

Expert Comment

by:Steven Harris
ID: 39631082
Are you trying to get into the VBA Panel itself?

Alt+F11 or enbale the Developer Tab and choose Visual Basic.

Optionally, if you are working on a project that has objects, such as Buttons or Dropdown boxes, you can right-click the object and select View Code.

View Code
What they actually may be referencing is the Worksheet Title...

Worksheet - View Code
0
 
LVL 12

Accepted Solution

by:
Harry Lee earned 500 total points
ID: 39631368
Mike,

I'm not sure which book are you reading, but I can tell you that there are lots of errors in books.

The easiest way to see the vba code of the workbook is to go into VBA Editor by pressing Alt-F11, then double click on ThisWorkBook under VBAProject (filename) filename should be the file you are working on, in the Project Explorer on the left. See Picture below.
VBA Editor Screen ShotIf Project Explorer is not on the screen, you can press Ctrl-R to show it.
0
 

Author Comment

by:mikecox_
ID: 39634836
fyi the book is "Excel 2010; power programming with VBA",  the exact line is under the heading: "Activating the VBE" and the instruction I was referring to is "you can access two special modules as follows... Right-click a workbook's little bar and choose View Code..."

But, as you can see from my question, I assume what I was pointing to is the "title bar" but it appears to be inert. Rt clicking only brings up the "restore move..." options.

Note the reference was definitely  "workbook", not worksheet.

It would appear that the instruction was a  mistake.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now