+ Reply to Thread
Results 1 to 2 of 2

Macro - Refresh Multiple Protected Pivtos (on Multiple Sheets) Upon Workbook Opening

  1. #1
    Registered User
    Join Date
    07-17-2013
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    27

    Macro - Refresh Multiple Protected Pivtos (on Multiple Sheets) Upon Workbook Opening

    Hi,

    I am having some really big trouble with a VBA code problem on an excel database of mine (I am pretty new to VBA writing so a dummies guide would be great).

    I have a workbook with six separate worksheets each containing pivot tables running off the same data table.

    Each sheet is password protected - If possible I would like to write a macro by where when the workbook is opened - the macro automatically runs - unprotects the sheets - refreshes all of the pivots - re-protects the sheets.

    I have tried to write something through my own learning but what seems to happen is that once the macro has run, the data table isn't protected and therefore the cells can be edited which I don't want.

    I want all of the sheets to be protected with the exception of a range of cells in the data table by where they can be edited (requested via a password)

    I don't know how to write the code or where to put it.

    Any quick responses and help would be hugely helpful and I would be eternally grateful.

    I have the database to send if that is easier for anybody.

    Thank you for all you time,

    Luke

  2. #2
    Registered User
    Join Date
    07-17-2013
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    27

    Re: Macro - Refresh Multiple Protected Pivtos (on Multiple Sheets) Upon Workbook Opening

    Any help at all would be so appreciated - really struggling with this.

    Thanks,

    Luke

+ 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. Vba/macro to combine multiple workbooks with multiple sheets into one workbook
    By ReshayM in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 09-03-2015, 01:00 PM
  2. [SOLVED] hide specific columns on multiple sheets with protected cells when workbook is closed
    By jrosko1 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-15-2013, 03:00 PM
  3. [SOLVED] Macro to copy cells from multiple sheets in workbook to multiple sheets in other workbook
    By KeithMale in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-13-2013, 05:37 PM
  4. Hide/unhidden rows in protected workbook multiple sheets
    By wachinnai in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-08-2012, 02:26 PM
  5. VBA Code to Refresh Pivots on multiple Sheets in a Workbook
    By xlguy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-06-2007, 03:58 PM

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