Display of VBA Code

User avatar
Don Wells
5StarLounger
Posts: 689
Joined: 27 Jan 2010, 16:45
Location: Ottawa, Ontario, Canada

Display of VBA Code

Post by Don Wells »

I am running Office 2003 SP3.

I am used to viewing all procedures in a given module in one window with separator bars between each procedure.

My display has switched to one procedure at any one time visible in the window. I cannot recall the keystrokes required to set/reset the switch which controls this.

Help.
Regards
Don

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Display of VBA Code

Post by HansV »

In the Visual Basic Editor, select Tools | Options...
In the Window Settings section of the Editor tab, tick the check box "Default to Full Module View".
Click OK.
Best wishes,
Hans

User avatar
Don Wells
5StarLounger
Posts: 689
Joined: 27 Jan 2010, 16:45
Location: Ottawa, Ontario, Canada

Re: Display of VBA Code

Post by Don Wells »

Thank you Hans.

The box was already checked; however unchecking it followed by OK, then resetting it did the trick. :confused3:
Regards
Don

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Display of VBA Code

Post by HansV »

Apparently a bit fell over, perhaps it was hit by a cosmic ray... :evilgrin:
Best wishes,
Hans

User avatar
Don Wells
5StarLounger
Posts: 689
Joined: 27 Jan 2010, 16:45
Location: Ottawa, Ontario, Canada

Re: Display of VBA Code

Post by Don Wells »

:bow: Thank you again Hans
Regards
Don

User avatar
Nick Vittum
4StarLounger
Posts: 475
Joined: 21 Feb 2020, 21:27
Location: Vermont (USA)

Re: Display of VBA Code

Post by Nick Vittum »

HansV wrote:
18 Sep 2012, 13:37
Apparently a bit fell over, perhaps it was hit by a cosmic ray...
:laugh:
—Nick

I’m only an egg (but hard-boiled)