Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to keep sheet modules collapsed?
Why is that the sheet modules or "microsoft excel objects" expands
when I switch from the VBE to Excel? In one project, I have 50+ sheet modules, which I keep collapsed while working in my normal modules. This way I'm not distracted by all the sheet modules when scrolling to other modules. I then switch over to the Excel workbook to work in the cells. When I switch back to the VBE, all the sheet modules are no longer collapsed. I have to keep collapsing them when returning to the VBE, they won't remain collapsed. Is there any way to prevent this? Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to keep sheet modules collapsed?
I'n my experience all you can do is protect the project, which is great for
completes add-ins you don't need to mess with, but that hides the whole thing until you unprotect it. HTH, Smitty "Gregg" wrote: Why is that the sheet modules or "microsoft excel objects" expands when I switch from the VBE to Excel? In one project, I have 50+ sheet modules, which I keep collapsed while working in my normal modules. This way I'm not distracted by all the sheet modules when scrolling to other modules. I then switch over to the Excel workbook to work in the cells. When I switch back to the VBE, all the sheet modules are no longer collapsed. I have to keep collapsing them when returning to the VBE, they won't remain collapsed. Is there any way to prevent this? Thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to keep sheet modules collapsed?
"Gregg" wrote:
Why is that the sheet modules or "microsoft excel objects" expands when I switch from the VBE to Excel? In one project, I have 50+ sheet modules, which I keep collapsed while working in my normal modules. This way I'm not distracted by all the sheet modules when scrolling to other modules. I then switch over to the Excel workbook to work in the cells. When I switch back to the VBE, all the sheet modules are no longer collapsed. I have to keep collapsing them when returning to the VBE, they won't remain collapsed. Is there any way to prevent this? Thanks.- Hide quoted text - - Show quoted text - On Aug 1, 10:00 pm, Smitty wrote: I'n my experience all you can do is protect the project, which is great for completes add-ins you don't need to mess with, but that hides the whole thing until you unprotect it. HTH, Smitty Right. But once it's unlocked, there's no way to keep the sheet modules collapsed, right? So, is everyone else having to deal with this too? It's not just me, right? I was afraid I was missing a work-around. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to keep sheet modules collapsed?
I'd forgotten about this one: www.mztools.com.
It's a free add-in for the VBE that includes an option to collapse groups. I think that's about the best you're gonna get... Smitty "Gregg" wrote: "Gregg" wrote: Why is that the sheet modules or "microsoft excel objects" expands when I switch from the VBE to Excel? In one project, I have 50+ sheet modules, which I keep collapsed while working in my normal modules. This way I'm not distracted by all the sheet modules when scrolling to other modules. I then switch over to the Excel workbook to work in the cells. When I switch back to the VBE, all the sheet modules are no longer collapsed. I have to keep collapsing them when returning to the VBE, they won't remain collapsed. Is there any way to prevent this? Thanks.- Hide quoted text - - Show quoted text - On Aug 1, 10:00 pm, Smitty wrote: I'n my experience all you can do is protect the project, which is great for completes add-ins you don't need to mess with, but that hides the whole thing until you unprotect it. HTH, Smitty Right. But once it's unlocked, there's no way to keep the sheet modules collapsed, right? So, is everyone else having to deal with this too? It's not just me, right? I was afraid I was missing a work-around. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to keep sheet modules collapsed?
"Gregg" wrote:
"Gregg" wrote: Why is that the sheet modules or "microsoft excel objects" expands when I switch from the VBE to Excel? In one project, I have 50+ sheet modules, which I keep collapsed while working in my normal modules. This way I'm not distracted by all the sheet modules when scrolling to other modules. I then switch over to the Excel workbook to work in the cells. When I switch back to the VBE, all the sheet modules are no longer collapsed. I have to keep collapsing them when returning to the VBE, they won't remain collapsed. Is there any way to prevent this? Thanks.- Hide quoted text - - Show quoted text - On Aug 1, 10:00 pm, Smitty wrote: I'n my experience all you can do is protect the project, which is great for completes add-ins you don't need to mess with, but that hides the whole thing until you unprotect it. HTH, Smitty Right. But once it's unlocked, there's no way to keep the sheet modules collapsed, right? So, is everyone else having to deal with this too? It's not just me, right? I was afraid I was missing a work-around.- Hide quoted text - - Show quoted text - On Aug 4, 2:36 pm, Smitty wrote: I'd forgotten about this one:www.mztools.com. It's a free add-in for the VBE that includes an option to collapse groups. I think that's about the best you're gonna get... Smitty I love it! 'Not what I was asking for, but I've never seen this tool and have lots of uses for it. Anymore cool tools like that? Thanks! |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to keep sheet modules collapsed?
Quote:
Google search will turn it up. It allows scrolling in the VBE. Smitty "Gregg" wrote: "Gregg" wrote: "Gregg" wrote: Why is that the sheet modules or "microsoft excel objects" expands when I switch from the VBE to Excel? In one project, I have 50+ sheet modules, which I keep collapsed while working in my normal modules. This way I'm not distracted by all the sheet modules when scrolling to other modules. I then switch over to the Excel workbook to work in the cells. When I switch back to the VBE, all the sheet modules are no longer collapsed. I have to keep collapsing them when returning to the VBE, they won't remain collapsed. Is there any way to prevent this? Thanks.- Hide quoted text - - Show quoted text - On Aug 1, 10:00 pm, Smitty wrote: I'n my experience all you can do is protect the project, which is great for completes add-ins you don't need to mess with, but that hides the whole thing until you unprotect it. HTH, Smitty Right. But once it's unlocked, there's no way to keep the sheet modules collapsed, right? So, is everyone else having to deal with this too? It's not just me, right? I was afraid I was missing a work-around.- Hide quoted text - - Show quoted text - On Aug 4, 2:36 pm, Smitty wrote: I'd forgotten about this one:www.mztools.com. It's a free add-in for the VBE that includes an option to collapse groups. I think that's about the best you're gonna get... Smitty I love it! 'Not what I was asking for, but I've never seen this tool and have lots of uses for it. Anymore cool tools like that? Thanks! |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to keep sheet modules collapsed?
Got it. That's making my life a lot easier.
Thanks! On Aug 6, 1:18 am, Smitty wrote: Quote:
If you're pre Office 12 you can check out VBScroll by Shahin Gasanov. A Google search will turn it up. It allows scrolling in the VBE. Smitty "Gregg" wrote: "Gregg" wrote: "Gregg" wrote: Why is that the sheet modules or "microsoft excel objects" expands when I switch from the VBE to Excel? In one project, I have 50+ sheet modules, which I keep collapsed while working in my normal modules. This way I'm not distracted by all the sheet modules when scrolling to other modules. I then switch over to the Excel workbook to work in the cells. When I switch back to the VBE, all the sheet modules are no longer collapsed. I have to keep collapsing them when returning to the VBE, they won't remain collapsed. Is there any way to prevent this? Thanks.- Hide quoted text - - Show quoted text - On Aug 1, 10:00 pm, Smitty wrote: I'n my experience all you can do is protect the project, which is great for completes add-ins you don't need to mess with, but that hides the whole thing until you unprotect it. HTH, Smitty Right. But once it's unlocked, there's no way to keep the sheet modules collapsed, right? So, is everyone else having to deal with this too? It's not just me, right? I was afraid I was missing a work-around.- Hide quoted text - - Show quoted text - On Aug 4, 2:36 pm, Smitty wrote: I'd forgotten about this one:www.mztools.com. It's a free add-in for the VBE that includes an option to collapse groups. I think that's about the best you're gonna get... Smitty I love it! 'Not what I was asking for, but I've never seen this tool and have lots of uses for it. Anymore cool tools like that? Thanks!- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
code modules included in sheet count? | Excel Programming | |||
Can I sum an outlined Excel sheet and ignore collapsed rows? | Excel Worksheet Functions | |||
How can I allow an outline to be collapsed on a protected sheet? | Excel Worksheet Functions | |||
Find and Replace code in Sheet modules | Excel Programming | |||
When to code in sheet or userform modules and when to use modules | Excel Programming |