+ 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 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

    don't link it. use code to populate the cell in the change event of the combobox (or the assigned macro if it's a Forms control)
    Josie

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

  2. #2
    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

    Okay that sounds good, only if I knew how to do that. Keep in mind though, there are other VB code and worksheets that are feeding off of the information that cell link provides. Thoughts?

  3. #3
    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

    Also of note, the "Input Range" remains locked, and the comboBox still works. However, only the "Cell link" is the issue when locked.

+ 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