Rubberduck: Feature: Show/Hide/Veryhide sheet
Hi, inside VBE -> Project tree, there is a branch named "Microsoft Excel Objects" with listed Sheets. When I click on sheet by right button, in context menu is shown Rubberduck item with some subitems. My proposal is to add to these subitems two extra subitems (third is the current state) to modify .Visible parameter of Sheet:
inDeev
All 2 comments
While I agree that this could be nice, sheet visibility is one arbitrarily cherry-picked property among dozens of others, that is specific to Excel.Worksheet modules; I'm not convinced special-casing it is a good idea.
That said, I see you're using the VBE's "project explorer" - did you know you could organize your modules into a custom folder hierarchy with Rubberduck's Code Explorer toolwindow?
retailcoder
on 31 Oct 2018
Since you're in the VBE anyway, typing Sheet1.Visible = xlSheetVeryHidden in the Immediate Pane isn't too much more difficult, especially with IntelliSense doing most of the typing for you.
daFreeMan
on 31 Oct 2018
Related issues
retailcoder
路
3Comments
retailcoder
路
4Comments
ChrisBrackett
路
3Comments
connerk
路
3Comments
Hosch250
路
3Comments
Most helpful comment
While I agree that this could be nice, sheet visibility is one arbitrarily cherry-picked property among dozens of others, that is specific to Excel.Worksheet modules; I'm not convinced special-casing it is a good idea.
That said, I see you're using the VBE's "project explorer" - did you know you could organize your modules into a custom folder hierarchy with Rubberduck's Code Explorer toolwindow?