+ Reply to Thread
Results 1 to 3 of 3

Locking Cells

  1. #1
    Registered User
    Join Date
    12-13-2012
    Location
    NE England
    MS-Off Ver
    Excel 2007
    Posts
    11

    Locking Cells

    Hi
    Is there a way where by I can enter a "x" Col N and the cells highlighted in yellow would be locked. This would be a progressive thing throught the year therefore more "x"s would be added on a monthly basis. Failing that, could the entire row be locked? By Locked I mean Cell Properties/Protection and tick the 'locked' box.

    Thanks
    AD
    Attached Files Attached Files
    Last edited by ad013; 12-14-2012 at 04:49 AM.

  2. #2
    Forum Contributor dogberry's Avatar
    Join Date
    07-15-2012
    Location
    Wales, UK
    MS-Off Ver
    Excel 2010
    Posts
    624

    Re: Locking Cells

    Hi

    Not that I am aware of from standard operation. If you get no reponse to this one over the nest couple of days post it in the VBA section as this my be possible with a bit of programming which is way beyond me at the moment.


    Chris
    Click my star if I helped Thanks

  3. #3
    Registered User
    Join Date
    12-13-2012
    Location
    NE England
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Locking Cells

    Ahh OK, I was wondering if that might be the case - still new to all this.

    Thanks for the heads up.
    AD

+ 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