+ Reply to Thread
Results 1 to 2 of 2

MS Excel Objects Lock Row based on Value working with Other Objects

  1. #1
    Registered User
    Join Date
    07-18-2018
    Location
    San Antonio, TX
    MS-Off Ver
    2016, 32-bit Version
    Posts
    13

    MS Excel Objects Lock Row based on Value working with Other Objects

    I have programming, with major help from others, that works great for two separate workbooks. The problem is that I can't seem to have them both work within the same workbook and I don't know why.

    We have a large contact database (4800 rows) workbook with a lot of sorting macros. I use the following to allow the user to double-click a cell to select or de-select a contact. This is under the Excel Objects, Sheet1 (MASTER):
    Please Login or Register  to view this content.
    In another workbook, I tested the following for locking a particular row if an 'X' is placed in Column AZ (end of contact data). This is under the Excel Objects, Sheet1 (Sheet1):

    Please Login or Register  to view this content.
    In the Database file, I have certain rows that identify the contact's category that I would like to have locked. All other cells can be changed. If I copy over the 2nd code to the database file, it doesn't work correctly. Instead it locks all of the cells and prompts the message box regardless of an 'X' in Column AZ. Can these two not co-exist or what is this newb doing wrong?

    Thanks!

  2. #2
    Registered User
    Join Date
    07-18-2018
    Location
    San Antonio, TX
    MS-Off Ver
    2016, 32-bit Version
    Posts
    13

    Re: MS Excel Objects Lock Row based on Value working with Other Objects

    Anybody? Would really appreciate the help!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Lock (freeze?!) objects
    By luizmachado in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 03-09-2023, 08:28 AM
  2. Replies: 9
    Last Post: 10-18-2018, 05:02 PM
  3. [SOLVED] Count how many objects are between two objects with serial numbers
    By noctornus in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-22-2016, 03:30 PM
  4. Count how many objects are between two objects with serial numbers
    By noctornus in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-22-2016, 12:21 PM
  5. Show/Hide objects no longer working in Excel 2013
    By kaaskiwi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-25-2015, 07:07 PM
  6. How to hide a selection of objects but show objects automatically when opening wkbk
    By slowjo1414 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-05-2013, 05:24 PM
  7. How to protect or lock only a few chards (objects), but not all of them?
    By Fresh-Young-Cheese in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 11-02-2012, 03:50 AM

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