+ Reply to Thread
Results 1 to 2 of 2

VBA - auto run macro

  1. #1
    Registered User
    Join Date
    05-12-2008
    Posts
    2

    VBA - auto run macro

    Hi,

    I've got a checkbox which i've linked to a cell.

    Then 4 rows will get the TRUE or False result from this tick box.

    I've added macro buttons which hide & unhide when TRUE or False, however is there (and if so what is) the formula for setting the macro that i don't need to use the buttons to hide/unhide.

    In other words when i untick the box, which changes the cell value to False then the macro will run to hide the rows which have FALSE in them.

    I've attached the spreadsheet (with instructions).

    Column B determines whether the row should be hidden. Some cells need to remain so i have given them the value TRUE.

    Thanks,
    Misha
    Attached Files Attached Files

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967
    Try adding this macro to the New timesheet tab in the VBA editor

    Please Login or Register  to view this content.
    Martin

+ Reply to Thread

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