+ Reply to Thread
Results 1 to 2 of 2

Excel 2008 : Automatically hiding or unhiding rows

  1. #1
    Registered User
    Join Date
    03-31-2012
    Location
    Manitowoc, WI
    MS-Off Ver
    Excel 2007
    Posts
    1

    Automatically hiding or unhiding rows

    Lets say Rows 7:59 are hidden on sheet X. Sheet X is a protected sheet because it is full of crazy formulas. All of the Data from Sheet X is pulled from Sheet Y. I need Rows 7:59 on Sheet X, to unhide depending on whether or not data is entered into Rows 7:59 on Sheet Y. For instance if Nothing is in Rows 7:59 on Sheet Y, then Rows 7:59 on Sheet X remain hidden. However If Enter Data into Sheet Y A7:8, I need Rows 7 and 8 on Sheet X to unhide automatically, but Rows 9:59 to remain hidden. I am using Excel 2008 for Mac, and from my understanding It doesnt support VBA, or the ability to use Macros, which may be the same thing, I don't know. Im not very versed when it comes to either one of those things. It would be very similar to an auto filter on Sheet X, except on a protected sheet in this version of Excel I havent found a way to allow autofiltering. There has to be a way to do this. Please Help

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885

    Re: Automatically hiding or unhiding rows

    Hi JTurk, welcome to the forum.

    Without VBA (same as "macros") I don't think you'll be able to accomplish this task. Your best bet would be to use Office 2004 (which still contains VBA) or upgrade to Office 2011 - which from what I've read once again includes VBA.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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