+ Reply to Thread
Results 1 to 3 of 3

Macro buttons on a Protected Worksheet not working

  1. #1
    Registered User
    Join Date
    10-06-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    10

    Macro buttons on a Protected Worksheet not working

    Hi all,

    I am trying to get my Macro buttons working on my worksheet when the worksheet is protected to stop tinkering.

    The buttons at the top left basically move the sheet to the corresponding month to save searching or scrolling. Wondered if anyone could help please.

    Buttons work fine when unprotected.

    Thanks in advance.

    AliG
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor Eastw00d's Avatar
    Join Date
    02-29-2020
    Location
    Breda, NL
    MS-Off Ver
    2016, 2019
    Posts
    833

    Re: Macro buttons on a Protected Worksheet not working

    Hi, you could go for this approach per macro:
    Please Login or Register  to view this content.
    Cheers
    Eastw00d
    I started learning VBA because I was lazy ...
    Still developing.... being more lazy...

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,476

    Re: Macro buttons on a Protected Worksheet not working

    You have Locked protection on the goto cell AND protection of the sheet with Locked cells as not selectable.

    If you temporarily remove protection you can goto the cell but applying protection will move the active cell.

    How about using

    Please Login or Register  to view this content.
    You will need to apply the protection within the workbook open event
    Cheers
    Andy
    www.andypope.info

+ 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. Macros not working on protected worksheet
    By brentjohn in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-03-2018, 08:06 PM
  2. Macro/VBA Buttons not working when sheet is password protected
    By targus92 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-04-2016, 01:45 PM
  3. Macro for allowing access for users to click buttons when sheet is protected
    By targus92 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-04-2016, 12:29 PM
  4. Data Validation Macro stops working when worksheet is protected
    By keeferino in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-06-2014, 02:28 PM
  5. Insert & Delete Buttons - Protected Worksheet
    By cjwescott in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-08-2013, 04:26 PM
  6. Maximising rows and using macro buttons on a protected worksheet
    By 3smees23 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-11-2012, 04:09 AM
  7. Protected Worksheet - tabs stop working in certain areas
    By bucketowater in forum Excel General
    Replies: 0
    Last Post: 01-26-2006, 01:30 AM

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