Results 1 to 3 of 3

Variable Locked Cells dependant on cell change

Threaded View

freud1 Variable Locked Cells... 01-12-2010, 05:48 AM
Domski Re: Variable Locked Cells... 01-12-2010, 06:13 AM
freud1 Re: Variable Locked Cells... 01-12-2010, 07:09 AM
  1. #1
    Forum Contributor
    Join Date
    06-13-2008
    Location
    London, England
    MS-Off Ver
    2010
    Posts
    277

    Variable Locked Cells dependant on cell change

    Hi Guys,

    I'm trying to make a spreadsheet more secure to prevent unintentional changes.

    What i'm looking to do is to lock all cells so no changescan be made unless the user clicks column A.

    Column A should remain unlocked and when the user clicks it i would like the entire row unlocked for editing (but only after column A is clicked)

    I will run a macro to lock the entire sheet again once the sheet closes.

    can anyone help with this or point me in the right direction?

    many thanks
    Last edited by freud1; 01-12-2010 at 07:09 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