Results 1 to 11 of 11

hide & unhide columns on different sheet based on criteria

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-13-2017
    Location
    Hong Kong
    MS-Off Ver
    MS Office 365
    Posts
    481

    hide & unhide columns on different sheet based on criteria

    Hi all,

    I need a Macro that I can call with a keystroke to toggle between hiding and unhiding columns on a different sheet.

    My "view" sheet has all relevant attribute columns from the "Buy" sheet and clients can click the 'tick box' to keep columns visible or hide them. The Macro should NOT run every time they select or unselect a column, but rather whenever they are on the "Buy" sheet and use the keystroke e.g. "CTRL + SHIFT + 1", which then unhides and hides the columns just as specified on the "view" sheet.

    I have attached a sample workbook to make things more clear...
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Way to hide or unhide sheets based on selection criteria
    By jshrader in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-21-2016, 07:28 PM
  2. hide and unhide columns based on cell value
    By darijokesar in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 11-29-2014, 03:51 AM
  3. Hide/Unhide row based on given criteria w. no Trigger butn
    By m1zz13 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-18-2013, 06:31 AM
  4. Hide/Unhide Rows based on Criteria
    By Phillycheese5 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-04-2010, 02:11 PM
  5. Hide & Unhide columns based on a cell value
    By DaveNUFC in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-21-2010, 09:40 AM
  6. [SOLVED] Hide or Unhide certain columns based on a cell value
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-10-2006, 01:04 PM
  7. Replies: 1
    Last Post: 06-05-2006, 03:10 PM

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