+ Reply to Thread
Results 1 to 2 of 2

hide/unhide (not protect) VB code while edditing it

  1. #1
    Valued Forum Contributor luv2glyd's Avatar
    Join Date
    07-13-2008
    Location
    Seattle, WA, US
    MS-Off Ver
    Excel 2010
    Posts
    679

    Question hide/unhide (not protect) VB code while edditing it

    Is there a way to hide/unhide the VB code while editing it similar to hide/unhide commands in the worksheets? I have modules with several pages of code each and would be nice to be able to hide/minimize portions of code to be able to look at project as a whole while I edit it. I do not need to protect/lock it, just be able to hide/unhide to view the project better.
    You either quit or become really good at it. There are no other choices.

  2. #2
    Valued Forum Contributor Neil_'s Avatar
    Join Date
    04-19-2013
    Location
    Yorkshire
    MS-Off Ver
    Office 365 Enterprise E3 2013 / 2016
    Posts
    479

    Re: hide/unhide (not protect) VB code while edditing it

    In the bottom left of the code window there are two little buttons which toggle between full module view and procedural view. Hope this helps! A good rule of thumb is to keep your procedures to one page. If they exceed this, consider writing functions to put your code into and call them from the main procedure. This makes code more readable and easier to edit

    Capture.PNG
    Last edited by Neil_; 01-19-2016 at 05:15 PM.
    Frob first, tweak later

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA code to hide/unhide worksheets
    By holli in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-26-2015, 11:34 AM
  2. [SOLVED] Hide Unhide Code
    By ando185 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-17-2013, 01:22 PM
  3. Replies: 2
    Last Post: 01-17-2013, 08:39 AM
  4. Protect the Hide/Unhide option
    By Bestycame in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-06-2011, 01:48 PM
  5. Password protected command button to protect/unprotect and hide/unhide
    By cpercival in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-07-2011, 03:27 PM
  6. Protect Sheet but Hide/Unhide Columns
    By N164PJ in forum Excel General
    Replies: 2
    Last Post: 12-17-2008, 07:51 PM
  7. Hide/Unhide in Code; Protect, Unlock, etc.
    By Sandy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-12-2005, 11:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1