Technique for switching to the VBE
 

Hi All,

In a book on vba Excel 2010, I read that we can activate the VBE and access
to the code module for the workbook with the following manner : Right-click
the workbook's title bar and choose View Code... (the workbook windows isn't
maximized)...but it doesn't run... It's not very important but have you try
this and does it run ?...

Thanks

GJ

Technique for switching to the VBE
 

Hi GJ,

Am Sun, 8 Jan 2012 12:30:45 +0100 schrieb GJ:

In a book on vba Excel 2010, I read that we can activate the VBE and access
to the code module for the workbook with the following manner : Right-click
the workbook's title bar and choose View Code... (the workbook windows isn't
maximized)...but it doesn't run... It's not very important but have you try
this and does it run ?...

try:
Alt+F11
or
Right click on sheets register and choose "View Code"


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Technique for switching to the VBE
 

hi GJ,

i didn't have xl2010 but it works correctly on xl2002


--
isabelle



Le 2012-01-08 06:30, GJ a écrit :
Hi All,

In a book on vba Excel 2010, I read that we can activate the VBE and access to the code module

for the workbook with the following manner : Right-click the workbook's title bar and choose View Code...

(the workbook windows isn't maximized)...but it doesn't run... It's not very important but have you try this and does it run ?...

Thanks

GJ

Technique for switching to the VBE
 

On Jan 8, 5:30*am, "GJ" wrote:
Hi All,

In a book on vba Excel 2010, I read that we can activate the VBE and access
to the code module for the workbook with the following manner : Right-click
the workbook's title bar and choose View Code... (the workbook windows isn't
maximized)...but it doesn't run... It's not very important but have you try
this and does it run ?...

Thanks

GJ

Get your money back. It's the workSHEET tab to right click. View code
takes you to THAT sheet's vbe and you can then navigate to the others
or the regular modules.

Technique for switching to the VBE
 

Don Guillett wrote:

On Jan 8, 5:30*am, "GJ" wrote:
Hi All,

In a book on vba Excel 2010, I read that we can activate the VBE and
access to the code module for the workbook with the following manner :
Right-click the workbook's title bar and choose View Code... (the
workbook windows isn't maximized)...but it doesn't run... It's not very
important but have you try this and does it run ?...

Thanks

GJ

Get your money back. It's the workSHEET tab to right click. View code
takes you to THAT sheet's vbe and you can then navigate to the others
or the regular modules.

Actually, if you do as GJ said -- have the workbook unmaximized, right-click
workbook's title bar -- you get a popup menu with the same "view source"
item. Works for me under both 2000 & 2007.

Personally, I prefer Alt+F11, as Claus mentioned. Faster & usually more
convenient.

(My minor bitch here is the fact that Alt+- no longer works in 2007 if the
workbook is maximized.)

--
We are about to change history.

Technique for switching to the VBE
 

On Sun, 8 Jan 2012 13:49:57 +0000 (UTC), "Auric__" wrote:

Actually, if you do as GJ said -- have the workbook unmaximized, right-click
workbook's title bar -- you get a popup menu with the same "view source"
item. Works for me under both 2000 & 2007.

Interesting. There must be some environmental setting because when I do that, in Excel 2007, I get the

Restore
Move
Size
Minimize
Maximize
Close

right click options -- same behavior as with the title bar for virtually evey other windo.

Technique for switching to the VBE
 

Auric__ wrote on 1/8/2012 :
Don Guillett wrote:

On Jan 8, 5:30*am, "GJ" wrote:
Hi All,

In a book on vba Excel 2010, I read that we can activate the VBE and
access to the code module for the workbook with the following manner :
Right-click the workbook's title bar and choose View Code... (the
workbook windows isn't maximized)...but it doesn't run... It's not very
important but have you try this and does it run ?...

Thanks

GJ

Get your money back. It's the workSHEET tab to right click. View code
takes you to THAT sheet's vbe and you can then navigate to the others
or the regular modules.

Actually, if you do as GJ said -- have the workbook unmaximized, right-click
workbook's title bar -- you get a popup menu with the same "view source"
item. Works for me under both 2000 & 2007.

Personally, I prefer Alt+F11, as Claus mentioned. Faster & usually more
convenient.

(My minor bitch here is the fact that Alt+- no longer works in 2007 if the
workbook is maximized.)

Alt+F11 works for me under xl9 to xl12, regardless of the workbook wind
size, even in 'Full Screen' view. Must be something wrong with your
version.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

Technique for switching to the VBE
 

GJ explained :
Hi All,

In a book on vba Excel 2010, I read that we can activate the VBE and access
to the code module for the workbook with the following manner : Right-click
the workbook's title bar and choose View Code... (the workbook windows isn't
maximized)...but it doesn't run... It's not very important but have you try
this and does it run ?...

Thanks

GJ

Are you trying to access the VBE to write code for YOUR own project,
*OR* are you wanting to look at code in someone else's project. If the
latter, maybe their project locks you out so you can't get to the code!

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

Technique for switching to the VBE
 

Ron Rosenfeld wrote:

On Sun, 8 Jan 2012 13:49:57 +0000 (UTC), "Auric__"
wrote:

Actually, if you do as GJ said -- have the workbook unmaximized,
right-click workbook's title bar -- you get a popup menu with the same
"view source" item. Works for me under both 2000 & 2007.

Interesting. There must be some environmental setting because when I do
that, in Excel 2007, I get the

Restore
Move
Size
Minimize
Maximize
Close

right click options -- same behavior as with the title bar for virtually
evey other windo.

Is that the app's title bar, or the workbook's? Excel's title bar should give
that menu; right-clicking the *unmaximized* workbook's title bar under 2007
gives me this:
Save
Save As...
Print...
Page Setup...
Spelling...
-
New Window
Arrange...
Zoom...
-
View Code

IIRC 2000's menu is different, but does include "View Code"... somewhere.

--
- I am La Gatita Demonica!
- I am Chupacornbread!

Technique for switching to the VBE
 

GS wrote:

Auric__ wrote on 1/8/2012 :
Don Guillett wrote:

On Jan 8, 5:30*am, "GJ" wrote:
Hi All,

In a book on vba Excel 2010, I read that we can activate the VBE and
access to the code module for the workbook with the following manner
: Right-click the workbook's title bar and choose View Code... (the
workbook windows isn't maximized)...but it doesn't run... It's not
very important but have you try this and does it run ?...

Thanks

GJ

Get your money back. It's the workSHEET tab to right click. View code
takes you to THAT sheet's vbe and you can then navigate to the others
or the regular modules.

Actually, if you do as GJ said -- have the workbook unmaximized,
right-click workbook's title bar -- you get a popup menu with the same
"view source" item. Works for me under both 2000 & 2007.

Personally, I prefer Alt+F11, as Claus mentioned. Faster & usually more
convenient.

(My minor bitch here is the fact that Alt+- no longer works in 2007 if
the workbook is maximized.)

Alt+F11 works for me under xl9 to xl12, regardless of the workbook wind
size, even in 'Full Screen' view. Must be something wrong with your
version.

Alt+F11 works for me too. I meant that Alt+- (dash/hypen) doesn't work under
2007 (and probably other versions with the ribbon instead of "normal" menus;
no experience on my end) with the workbook maximized.

--
Tonya ripped out all of Charlie Brown's hair but left a single strand
to remind him one day she'd come back to eat him.

Technique for switching to the VBE
 

Ron

Sounds like you are right-clicking on the Application Title Bar.

Restore the workbook window down inside a maximized application window
then r-click on the workbook title bar.

I get same menu on Excel 2003 or 2007 under same circumstances.

NOTE: I am running Windows 7

Does that make a difference?


Gord

On Sun, 08 Jan 2012 19:09:14 -0500, Ron Rosenfeld
wrote:

On Sun, 8 Jan 2012 13:49:57 +0000 (UTC), "Auric__" wrote:

Actually, if you do as GJ said -- have the workbook unmaximized, right-click
workbook's title bar -- you get a popup menu with the same "view source"
item. Works for me under both 2000 & 2007.

Interesting. There must be some environmental setting because when I do that, in Excel 2007, I get the

Restore
Move
Size
Minimize
Maximize
Close

right click options -- same behavior as with the title bar for virtually evey other windo.

Technique for switching to the VBE
 

like that,

http://cjoint.com/?BAjfhkBhHSC

when you click View Code you are directed to the ThisWorkbook page

--
isabelle

Technique for switching to the VBE
 

try this,


Sub Test1()
Application.CommandBars("Document").Controls("View Code").Execute
End Sub


Sub Test2()
Application.CommandBars("Ply").Controls("View Code").Execute
End Sub


--
isabelle



Le 2012-01-08 23:12, isabelle a écrit :
like that,

http://cjoint.com/?BAjfhkBhHSC

when you click View Code you are directed to the ThisWorkbook page

Technique for switching to the VBE
 

Auric__ used his keyboard to write :
GS wrote:

Auric__ wrote on 1/8/2012 :
Don Guillett wrote:

On Jan 8, 5:30*am, "GJ" wrote:
Hi All,

In a book on vba Excel 2010, I read that we can activate the VBE and
access to the code module for the workbook with the following manner
Right-click the workbook's title bar and choose View Code... (the
workbook windows isn't maximized)...but it doesn't run... It's not
very important but have you try this and does it run ?...

Thanks

GJ

Get your money back. It's the workSHEET tab to right click. View code
takes you to THAT sheet's vbe and you can then navigate to the others
or the regular modules.

Actually, if you do as GJ said -- have the workbook unmaximized,
right-click workbook's title bar -- you get a popup menu with the same
"view source" item. Works for me under both 2000 & 2007.

Personally, I prefer Alt+F11, as Claus mentioned. Faster & usually more
convenient.

(My minor bitch here is the fact that Alt+- no longer works in 2007 if
the workbook is maximized.)

Alt+F11 works for me under xl9 to xl12, regardless of the workbook wind
size, even in 'Full Screen' view. Must be something wrong with your
version.

Alt+F11 works for me too. I meant that Alt+- (dash/hypen) doesn't work under
2007 (and probably other versions with the ribbon instead of "normal" menus;
no experience on my end) with the workbook maximized.

What does Alt+- have to do with accessing the VBE?

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

Technique for switching to the VBE
 

I try to write code for my own project ... I think as Ron Rosenfeld said
"There must be some environmental setting"
I use a french version because I live in France ... and I have a french
version of windows 7 ultimate 64 bits

Alt + F11 runs very well ... it's not a problem ...but it's interesting to
known why ...
Thanks for your response
GJ

"GS" a écrit dans le message de groupe de discussion :
...

GJ explained :
Hi All,

In a book on vba Excel 2010, I read that we can activate the VBE and
access to the code module for the workbook with the following manner :
Right-click the workbook's title bar and choose View Code... (the workbook
windows isn't maximized)...but it doesn't run... It's not very important
but have you try this and does it run ?...

Thanks

GJ

Are you trying to access the VBE to write code for YOUR own project,
*OR* are you wanting to look at code in someone else's project. If the
latter, maybe their project locks you out so you can't get to the code!

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

Technique for switching to the VBE
 

GS wrote:

Auric__ used his keyboard to write :
GS wrote:

Auric__ wrote on 1/8/2012 :
Don Guillett wrote:

On Jan 8, 5:30*am, "GJ" wrote:
Hi All,

In a book on vba Excel 2010, I read that we can activate the VBE
and access to the code module for the workbook with the following
manner
Right-click the workbook's title bar and choose View Code... (the
workbook windows isn't maximized)...but it doesn't run... It's not
very important but have you try this and does it run ?...

Thanks

GJ

Get your money back. It's the workSHEET tab to right click. View
code takes you to THAT sheet's vbe and you can then navigate to the
others or the regular modules.

Actually, if you do as GJ said -- have the workbook unmaximized,
right-click workbook's title bar -- you get a popup menu with the
same "view source" item. Works for me under both 2000 & 2007.

Personally, I prefer Alt+F11, as Claus mentioned. Faster & usually
more convenient.

(My minor bitch here is the fact that Alt+- no longer works in 2007
if the workbook is maximized.)

Alt+F11 works for me under xl9 to xl12, regardless of the workbook
wind size, even in 'Full Screen' view. Must be something wrong with
your version.

Alt+F11 works for me too. I meant that Alt+- (dash/hypen) doesn't work
under 2007 (and probably other versions with the ribbon instead of
"normal" menus; no experience on my end) with the workbook maximized.

What does Alt+- have to do with accessing the VBE?

Nothing. It was parenthesized minor bitching.

--
Communicating badly and then acting smug when you're misunderstood
is not cleverness.

Technique for switching to the VBE
 

On Mon, 9 Jan 2012 03:07:32 +0000 (UTC), "Auric__" wrote:

Is that the app's title bar, or the workbook's?

Duh. <sound of hand slapping forehead

Because the workbook title was in the app's title bar, I made that error. You're absolutely correct; un-maximizing the WORKBOOK (and not the app window), and right-clicking on that title bar does bring up the menu which included View Code.

Technique for switching to the VBE
 

On Sun, 08 Jan 2012 19:20:56 -0800, Gord Dibben wrote:

Sounds like you are right-clicking on the Application Title Bar.

I was. See my response to Auric_

Technique for switching to the VBE
 

OK you are right, I have made also that error
Thanks
GJ

"Ron Rosenfeld" a écrit dans le message de groupe de discussion :
...

On Mon, 9 Jan 2012 03:07:32 +0000 (UTC), "Auric__"
wrote:

Is that the app's title bar, or the workbook's?

Duh. <sound of hand slapping forehead

Because the workbook title was in the app's title bar, I made that error.
You're absolutely correct; un-maximizing the WORKBOOK (and not the app
window), and right-clicking on that title bar does bring up the menu which
included View Code.