+ Reply to Thread
Results 1 to 3 of 3

Excel doing something weird??

  1. #1
    Forum Contributor
    Join Date
    03-07-2013
    Location
    Montreal
    MS-Off Ver
    Excel 2007
    Posts
    274

    Excel doing something weird??

    Hello,

    Why is it that when my VBA code executes this line:

    ActiveSheet.PROTECT

    Why does Excel set the focus (Selects) cell AA3 ???

    rn

  2. #2
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,077

    Re: Excel doing something weird??

    If the active cell is a cell which is not allowed to be selected Excel finds another cell which may be selected.
    Possibly that is the first cell protection allows to select.
    Cheers!
    Tsjallie




    --------
    If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!

    If you think design is an expensive waste of time, try doing without ...

  3. #3
    Forum Contributor
    Join Date
    03-07-2013
    Location
    Montreal
    MS-Off Ver
    Excel 2007
    Posts
    274

    Re: Excel doing something weird??

    I suppose so

    thanks

+ 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. Weird Symbols in Excel
    By raviveda in forum Excel General
    Replies: 1
    Last Post: 12-23-2014, 12:40 AM
  2. Excel acting weird
    By jonbprime in forum Excel General
    Replies: 1
    Last Post: 08-24-2007, 10:55 AM
  3. Weird excel file
    By wei82 in forum Excel General
    Replies: 3
    Last Post: 07-12-2007, 02:26 AM
  4. [SOLVED] Excel weird behavior
    By [email protected] in forum Excel General
    Replies: 4
    Last Post: 05-25-2006, 03:30 PM
  5. Weird Excel Problem - Help!
    By JamboUK in forum Excel General
    Replies: 0
    Last Post: 11-30-2005, 08:31 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