+ Reply to Thread
Results 1 to 3 of 3

A macro that offsets (0,1), jumps 1 and goto next unlocked cell

  1. #1
    Forum Contributor
    Join Date
    11-02-2016
    Location
    brasil
    MS-Off Ver
    office 365 2016 windows
    Posts
    195

    A macro that offsets (0,1), jumps 1 and goto next unlocked cell

    Hi, I have this macro on a protected sheet. It will always take me to column E.
    Even if the cell is locked the cursor will be placed on column E. I can't select the cell in column E but the cursor will be there.

    Is there a way to tell... if cell is locked move to next cell that is unlocked. Is that possible?

    Please Login or Register  to view this content.
    Thank you

  2. #2
    Forum Contributor
    Join Date
    11-02-2016
    Location
    brasil
    MS-Off Ver
    office 365 2016 windows
    Posts
    195

    Re: A macro that offsets (0,1), jumps 1 and goto next unlocked cell

    Isnt'it curious that althought a cell is locked Excel is placing the cursor on those locked cells... just becaue of the offset? Any workaround?

  3. #3
    Forum Contributor
    Join Date
    11-02-2016
    Location
    brasil
    MS-Off Ver
    office 365 2016 windows
    Posts
    195

    Re: A macro that offsets (0,1), jumps 1 and goto next unlocked cell

    Solved with > EnableSelection = xlUnlockedCells

+ 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. Excel Macro that jumps to cell that has nearest to today's date
    By newman1234 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-07-2014, 06:02 AM
  2. Hitting Enter in an unlocked cell without it advancing to the next unlocked cell
    By GuruWannaB in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-15-2013, 09:47 AM
  3. Macro Help (IF A1 = Yes goto cell b100...)
    By nono5551212 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-17-2013, 10:30 PM
  4. [SOLVED] Goto to cell macro
    By jonrack in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-09-2012, 02:21 PM
  5. Macro to select the first unlocked visible cell when a sheet is activated
    By gazza365 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-19-2011, 02:01 AM
  6. Macro goto next blank cell
    By staples in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-20-2009, 11:09 AM
  7. Goto a dynamic cell address within a macro
    By blkane in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-08-2005, 02:05 PM

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