+ Reply to Thread
Results 1 to 15 of 15

How to globally get Macros to work around "Protected" /Locked Worksheets and Workbooks

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    05-19-2012
    Location
    Croatia
    MS-Off Ver
    Excel 2007
    Posts
    200

    Re: How to globally get Macros to work around "Protected" /Locked Worksheets and Workbooks

    Quote Originally Posted by JosephP View Post
    the input range isn't being changed so that's not an issue. is there a reason you can't unlock the linked cell?
    The main reason why cells are locked is because users who are not so computer savvy may inadvertently delete cells that they shouldn't, thus compromising the programming. So all cells are locked, except the ones for data entry.

    The user uses the "ComboBox" to make a selection and thus "changes" his choice based on the input range. And his choice generates a different result in the "Cell Link."

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: How to globally get Macros to work around "Protected" /Locked Worksheets and Workbooks

    Quote Originally Posted by nenadmail View Post
    So all cells are locked, except the ones for data entry.
    but the linked cell is for data entry. if they delete the contents then selecting an item from the combobox will reinstate the value.
    Josie

    if at first you don't succeed try doing it the way your wife told you to

+ 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