+ Reply to Thread
Results 1 to 3 of 3

Harcode values before protecting sheets.

  1. #1
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    2016
    Posts
    2,100

    Harcode values before protecting sheets.

    I have the following macros that will delete some sheets, hardcode the remaining ones and it should protect every sheet with a password. The problem is that the protection macro activates before hardcoding the sheets, returning an error. How can I bypass this issue?
    Also, how can I make sure that the only things that users are allowed to do is only to filter the data and use the slicers?

    Please Login or Register  to view this content.
    Click the * to say thanks.

  2. #2
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    2016
    Posts
    2,100

    Re: Harcode values before protecting sheets.

    Fixed the issue by removing the second macro and adding the protection line to the second For Each. The problem is that one of the sheets has a table with lots of cube based formulas and after running the macro everything changes it's place as if the hardcoding part failed

  3. #3
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    2016
    Posts
    2,100

    Re: Harcode values before protecting sheets.

    Second fix: Fixed by changing second For Each to:
    Please Login or Register  to view this content.

+ 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. Help w/ protecting all sheets
    By cnote in forum Excel General
    Replies: 8
    Last Post: 02-20-2013, 02:53 PM
  2. Protecting tabs and protecting sheets
    By jimstrongy in forum Excel General
    Replies: 0
    Last Post: 01-31-2012, 11:27 AM
  3. protecting sheets
    By sim in forum Excel General
    Replies: 13
    Last Post: 06-12-2011, 03:09 PM
  4. Protecting sheets
    By waddy in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-03-2007, 10:02 AM
  5. protecting all sheets at once
    By jerredjohnson in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-23-2007, 06:26 PM
  6. [SOLVED] Protecting Sheets
    By Joyce in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-20-2006, 04:25 PM
  7. [SOLVED] Protecting Sheets
    By albertmb in forum Excel General
    Replies: 7
    Last Post: 03-13-2006, 05:15 PM
  8. [SOLVED] Protecting Sheets with VBA
    By Helen in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-21-2005, 12:06 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