+ Reply to Thread
Results 1 to 3 of 3

Issues protecting sheets when macro runs filter

  1. #1
    Registered User
    Join Date
    07-17-2014
    Location
    Scotland
    MS-Off Ver
    2010
    Posts
    19

    Post Issues protecting sheets when macro runs filter

    Hi,

    I am have changed around the below macro to work on a few of my sheets. I have a few different buttons that I allow the user to click, and also a cell for them to type into when for the key words that they want to search.
    I want to protect multiple sheets(not the entire workbook) so that they can't move the buttons around. However when I do this the macro stops working. I tried ticking all boxes to eliminate the issue when protecting the sheet, but even with them all ticked the macro doesn't run.

    Please Login or Register  to view this content.
    Thanks in advance

    Colin

  2. #2
    Valued Forum Contributor Neil_'s Avatar
    Join Date
    04-19-2013
    Location
    Yorkshire
    MS-Off Ver
    Office 365 Enterprise E3 2013 / 2016
    Posts
    479

    Re: Issues protecting sheets when macro runs filter

    Hi, protect the sheet in code or through the immediate window setting the UserInterFaceOnly:=True. This enables macros to run on protected sheets

    Please Login or Register  to view this content.
    Frob first, tweak later

  3. #3
    Registered User
    Join Date
    07-17-2014
    Location
    Scotland
    MS-Off Ver
    2010
    Posts
    19

    Re: Issues protecting sheets when macro runs filter

    Thanks Neil. That works.

+ 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. My macro runs on hidden sheets (and it shouldn't)
    By nagonar in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-09-2015, 11:47 AM
  2. My macro runs on hidden sheets
    By nagonar in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-09-2015, 11:20 AM
  3. Advanced Filter: Macro Issues
    By thedutchrudder in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-09-2014, 10:15 AM
  4. Protecting Sheet in Shared Mode AND using a filter macro
    By Amanda81 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-17-2011, 10:09 AM
  5. Macro Protecting Sheets with Password
    By Emonk in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-26-2011, 03:24 PM
  6. Protecting Macro and selected sheets
    By ST in forum Excel General
    Replies: 1
    Last Post: 06-06-2006, 10:10 AM
  7. this macro runs, but not with a filter on the sheets?
    By matthias in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-11-2006, 04:45 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