+ Reply to Thread
Results 1 to 3 of 3

Unlocking sheet causes it to activate

  1. #1
    Registered User
    Join Date
    11-30-2012
    Location
    Belgium
    MS-Off Ver
    Excel 2003
    Posts
    1

    Unlocking sheet causes it to activate

    Hello!

    I'm having a weird problem with Excel 2013.

    When I use .Unprotect in VBA it causes the sheet to activate.

    Anyone else experiencing this problem?

    Thx

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,946

    Re: Unlocking sheet causes it to activate

    Post your code.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Unlocking sheet causes it to activate

    Quote Originally Posted by Sensui View Post
    Hello!

    I'm having a weird problem with Excel 2013.

    When I use .Unprotect in VBA it causes the sheet to activate.

    Anyone else experiencing this problem?

    Thx
    Not here.
    Are you sure the sheet that's activated wasn't already active when you started whatever macro is unprotecting it, or perhaps the macro itself is activating the sheet???
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ 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. Unlocking Range in a protected Sheet - VBA
    By sahal in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-15-2015, 08:02 AM
  2. Code to Activate a sheet 1 [IF] Userform box is "X" if not Activate Sheet 2
    By Invicta084 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-07-2014, 08:50 AM
  3. Execute email notification from sheet while unlocking sheet and then protect on exit
    By dillkeva in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-10-2013, 06:24 AM
  4. Unlocking Chart Axis Title under locked sheet without unlocking the sheet
    By dalelengle in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-16-2012, 08:59 PM
  5. Locking excel sheet without unlocking previously locked cells
    By ashileekay in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-06-2012, 10:23 AM
  6. unlocking some cells on a protected sheet
    By Frank49 in forum Excel General
    Replies: 1
    Last Post: 07-24-2012, 07:08 PM
  7. Unlocking Macro in protected sheet
    By mag7417 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-28-2005, 09:04 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