Closed Thread
Results 1 to 2 of 2

How to address locked cells, how to work with them

  1. #1
    Registered User
    Join Date
    11-23-2018
    Location
    Munich, Germany
    MS-Off Ver
    Office 2007
    Posts
    4

    How to address locked cells, how to work with them

    Hello Community

    I'm asking an English speaking forum, because I couldn't find an adequate answer in a German forum:

    How can I get the value of target.row and target.column despite the cell is locked? How can I do that? Leftclick, rightclick, a subroutine should be called for further processing.

    I am retired and spend time working with VBA Excel. I don't have much experience with that.
    I am interested because it is, as I see it, an exceptional program. I want to familiarize with it.

    Locked cells, how to work with them. I'm looking forward to an answer. Thank you in advance.

    Yours mggs68

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: How to address locked cells, how to work with them

    Welcome to the Forum, unfortunately this is a duplicate post and as such will now be closed, you may continue in your other thread.

    Thread Closed.
    HTH
    Regards, Jeff

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to address lLocked cells, how to work with them
    By mggs68 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-24-2018, 06:10 PM
  2. Button Macro to work on locked cells - URGENT
    By kvspawan19 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-14-2016, 02:47 AM
  3. Replies: 2
    Last Post: 11-18-2014, 12:21 PM
  4. Copy and paste locked cells, and have pasted cells retain LOCKED status.
    By stratloveslenny in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-16-2014, 03:05 PM
  5. Replies: 3
    Last Post: 04-12-2014, 04:47 AM
  6. [SOLVED] How to make this code work even if the cells are locked and sheet is protected
    By nenadmail in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-22-2012, 01:14 PM
  7. [SOLVED] not all cells are locked when protect is true for work sheet
    By Alexandre Brisebois (www.pointnetsolutions.com) in forum Excel General
    Replies: 3
    Last Post: 07-28-2005, 07:05 PM

Tags for this Thread

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