Results 1 to 4 of 4

VBA buttons for hide/unhide rows disappear at random

Threaded View

  1. #3
    Registered User
    Join Date
    03-28-2013
    Location
    San Francisco, CA
    MS-Off Ver
    Excel 2010
    Posts
    16

    Re: VBA buttons for hide/unhide rows disappear at random

    Sorry about that. I edited the first post to include the correct code.

    To answer your question: no, the buttons are all in rows that are unaffected by the macro. Their disappearance seems random. Regardless of which button is clicked, sometimes they all disappear, sometimes just a few disappear, and sometimes none disappear.

    There is other code in the document, but I have the same problem whether or not I use this other macro. I'm using a ThisWorkbook macro to protect the document because hide/unhide rows will not work with Excel's built-in protection. Here's the code I use for this:

    Private Sub Workbook_Open()
    With Worksheets("Sheet1")
           .Protect Password:="password", Userinterfaceonly:=True
           .EnableOutlining = True
    End With
    End Sub

    Also, I should mention that I'm not interested in a patch to fix my copy of Excel. This document is meant to go to several people, and I can't expect all of them to repair their software as well.
    Last edited by derekopswat; 04-01-2013 at 12:44 PM.

Thread Information

Users Browsing this Thread

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

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