Results 1 to 2 of 2

Lock Specific Range

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-28-2013
    Location
    singapore
    MS-Off Ver
    Excel 2010
    Posts
    157

    Lock Specific Range

    when some letters chose on one sheet , it will lock or protect certain range on another sheet . ?


    For example I have an sheet named FCT_PUB sheet ,(on Row 25)when a letter In Jan 14 "Y" is chose and you click update button. It will go to sheet name called Budget_ summary , it will locked and protect that January month column only . In FCT_PUB sheet ,(on Row 25)If other letters on JAN 14 , clicked "N" or "C" it will be unlocked and un-protected that January month only .


    pls help me, file is attached Thank you!
    Attached Files Attached Files
    Last edited by joh46k; 07-12-2013 at 06:29 AM.

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