Results 1 to 3 of 3

Lock Sheet (With specific settings..)

Threaded View

  1. #1
    Registered User
    Join Date
    01-14-2015
    Location
    Beja, Portugal
    MS-Off Ver
    2013
    Posts
    7

    Lock Sheet (With specific settings..)

    Hello there

    So, i have the following Macro for updating the Data on my Locked PivotTable sheet

    Sub Atualizar_Dados_Resumo_PessTD()
    Worksheets("Resumo Pessoal (TD)").Unprotect "password"
    ActiveSheet.Calculate
    Worksheets("Resumo Pessoal (TD)").Protect "password"
    End Sub
    The problem with this is that when you press the button embedded with this Macro, it locks the page in with default settings, and i would like to be able to lock it with a Macro that also allows the following settings : "Use AutoFilter"; "Use PivotTable & PivotChart"

    Why this ? The user of this Excel documents is supposed to be able to manipulate the PivotTable however he see's fit, but not change or delete any other data in the sheet. So what should i insert in the code for allowing those settings and at the same time protect the sheet with my chosen password ?
    Last edited by jcabroxo; 01-21-2015 at 12:10 PM. Reason: Issue solved

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel 2010 - Lock out Trust Center settings for Disabling All Macros?
    By tv69 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-13-2014, 10:31 AM
  2. [SOLVED] how to lock settings in pivot? stop updating info?
    By Mike11 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-23-2012, 08:44 PM
  3. Replies: 3
    Last Post: 06-30-2010, 09:46 AM
  4. Lock sheet tabs option in a specific workbook
    By Tarique in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-08-2006, 11:55 AM
  5. [SOLVED] Is there a way to lock in the toolbar settings??
    By kydan47 in forum Excel General
    Replies: 0
    Last Post: 03-30-2005, 10:06 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