More VBA Editor weirdness
 

When I view the code in a module, it now defaults to showing General /
Declarations and I can select procedures one at a time. What do I need to
change so that I can see the entire module?

Thanks,
Barb

More VBA Editor weirdness
 

There are two "views" to the code pane.

At the bottom left (just to the left of the left scroll arrow), you'll see two
little icons.

One looks kind of like this:

---
--
---

And the other looks like:
---
--
---
--
---

The leftmost is the "Procedure view" and the other is the "full module view".
You'll see these in the tooltip if you let the cursor linger over them.

Click the one you want. Each can be useful at different times. (You can scroll
up/scroll down to move between procedures, too--in either mode.)

Barb Reinhardt wrote:

When I view the code in a module, it now defaults to showing General /
Declarations and I can select procedures one at a time. What do I need to
change so that I can see the entire module?

Thanks,
Barb

--

Dave Peterson

More VBA Editor weirdness
 

In addition to Dave's method to dynamically swap back and forth between the
two view methods, you can set the default view from Tools/Options on the
Editor tab... the "Default to Full Module View" check box in the "Window
Settings" section controls which default view is used at start up.

--
Rick (MVP - Excel)


"Barb Reinhardt" wrote in message
...
When I view the code in a module, it now defaults to showing General /
Declarations and I can select procedures one at a time. What do I need
to
change so that I can see the entire module?

Thanks,
Barb