+ Reply to Thread
Results 1 to 1 of 1

Hiding columns without protecting Sheet

  1. #1
    Forum Contributor
    Join Date
    04-22-2017
    Location
    AU
    MS-Off Ver
    Microsoft 365
    Posts
    304

    Hiding columns without protecting Sheet

    HI All

    Have a Workbook with many tabs and some very complicated formulae in several columns which are hidden.
    I want to allow others workers to use workbook but not allow them to unhide the Columns.
    Sheet to remain unprotected as areas (including hidden columns) are allowed to be copied and pasted to same format down the sheet as extras are required.
    If column is hidden, then I assume formulae don't need to be hidden?

    Can someone please assist with VBA code to hide and unhide please?

    Example attached
    Attached Files Attached Files
    Last edited by VisionSmart; 01-30-2018 at 07:50 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Protecting sheet with grouped columns
    By DanteeChaos in forum Excel General
    Replies: 0
    Last Post: 07-24-2015, 03:49 AM
  2. Hiding Formulas without Protecting Sheet
    By znalron@yahoo.com in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-26-2012, 09:28 PM
  3. Protecting columns in a sheet
    By Cmorgan in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 02-21-2011, 07:57 PM
  4. Password protecting & hiding columns
    By OneChiOnly in forum Excel General
    Replies: 1
    Last Post: 11-28-2006, 05:48 PM
  5. Locking columns and not protecting whole sheet
    By changetires in forum Excel General
    Replies: 3
    Last Post: 07-13-2006, 12:50 PM
  6. Excel 2003 - Protecting and Hiding Columns
    By Peppermint in forum Excel General
    Replies: 2
    Last Post: 01-19-2006, 12:10 PM
  7. Hiding & Protecting Columns?
    By dbutler in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-21-2005, 06:38 PM

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