Results 1 to 2 of 2

Thread: [RESOLVED] Hiding columns when sheet protected.

  1. Oct 19th, 2011, 10:37 AM #1
    HughGabriel
    HughGabriel is offline

    Thread Starter
    New Member
    Join Date
    Sep 2011
    Posts
    8

    Resolved [RESOLVED] Hiding columns when sheet protected.

    I have a massive (150 column) sheet that it broken down into the items and 5 sections, with a combo box indirectly driving a macro to hide 4/5ths of it at a time.

    I need to protect the sheet, but this prevents any columns being hidden or unhidden both manually and by the combo box. How do I get round this?

    Thanks
    Hugh
    Reply With Quote Reply With Quote
  2. Oct 19th, 2011, 10:39 AM #2
    HughGabriel
    HughGabriel is offline

    Thread Starter
    New Member
    Join Date
    Sep 2011
    Posts
    8

    Re: [RESOLVED] Hiding columns when sheet protected.

    Just worked out how to do this, sorry!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width