Consulting

Results 1 to 9 of 9

Thread: VBA hiding and locking rows?

  1. #1

    VBA hiding and locking rows?

    Hello, a former employee did an excellent job on an Excel spreadsheet.
    For appearance purposes he hid rows 38 to 41. The Format, Rows, Unhide with row 37 and 42 highlighted does not reveal them.

    Could he have invoked a "super" hide command in VBA. If so how would I find it and remove it?

    Thanks

  2. #2
    Just A Dude VBAX Tutor Scottie P's Avatar
    Joined
    May 2004
    Location
    Remote from 18901 USA
    Posts
    263
    Location
    Hi Bob - Welcome to VBAX!


    One possibility that does exist is that the rows were resized and not hidden at all. Can you go to the dark dividing line beath row 37 (on the header itself, where the row numbers are) and try dragging it down?

    Let me know what you turn up!

    Scott
    Life is Visual: Presence is Perception...
    How we see the world is how we respond to it. ~* Peace *~

  3. #3
    Site Admin
    The Princess
    VBAX Guru Anne Troy's Avatar
    Joined
    May 2004
    Location
    Arlington Heights, IL
    Posts
    2,530
    Location
    Or, instead of that, you can Ctrl+A and set row height to the default 12.75.

    If there's VBA in the file, you should be asked to enable macros IF you have your Macro security set to Medium under Tools-Macro-Security. If you don't get the enable macros message, there's no code in the file.
    ~Anne Troy

  4. #4
    Thanks to Scott and Dreamboat for taking on my question. Another forum suggested a test and I FAILED. Excel WILL hide a row on a otherwise blank worksheet, also a column, but it WILL NOT unhide them. The worksheet I was trying to understand was not the problem. Rather it is Excel itself. As a test I removed all add ins and the result is the same. I did Detect and Repair but no change. Your thoughts will be welcome.

  5. #5
    Site Admin
    The Princess VBAX Guru Anne Troy's Avatar
    Joined
    May 2004
    Location
    Arlington Heights, IL
    Posts
    2,530
    Location
    Bob: Care to upload the file?
    You may need to hit GO ADVANCED below the reply box...
    ~Anne Troy

  6. #6
    The otherwise blank Excel worksheet with a hidden row and column entitled Dreamboat is attached.

  7. #7
    Site Admin
    The Princess VBAX Guru Anne Troy's Avatar
    Joined
    May 2004
    Location
    Arlington Heights, IL
    Posts
    2,530
    Location
    Okay. I thought it was a row. It's a column.
    Hit Ctrl+G.
    Type E1 and hit Enter.
    This takes you to cell E1.
    Now, from the menu, hit Format-Column, Width, and then type 10 or so in there.
    Hit Enter.
    ~Anne Troy

  8. #8
    GENIUS, sheer Genius.

    I will so seldom Hide either columns or rows the fact Excel doesn't automatically Unhide won't be an issue.

    Thank you very much.

  9. #9
    Site Admin
    The Princess VBAX Guru Anne Troy's Avatar
    Joined
    May 2004
    Location
    Arlington Heights, IL
    Posts
    2,530
    Location
    You're quite welcome.
    ~Anne Troy

Posting Permissions

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