+ Reply to Thread
Results 1 to 2 of 2

Unlocked sheet in a locked workbook: compromising security of WB?

  1. #1
    Registered User
    Join Date
    07-04-2020
    Location
    yeneb
    MS-Off Ver
    yeneb
    Posts
    1

    Unlocked sheet in a locked workbook: compromising security of WB?

    Hi,

    I have a workbook that is usually fully locked (structure, sheets & VBA) so users can't interfere with the structure or the data and can't see formulas in the file. Now, I would like to add a new tab that would be unlocked and is a blank page so users can use it to "build on" what's already provided by the spreadsheet and sort of customize the information to their needs.

    My question: is there any risks that I'm missing of providing a fully unlocked sheet in a workbook that is normally fully protected? (i.e. can they use this sheet to try to hack the VBA, workbook, etc or does it make no difference?). Just trying to avoid compromising my whole spreadsheet just to provide some customization solution to users.

    Thanks
    Last edited by AliGW; 07-04-2020 at 04:33 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,469

    Re: Unlocked sheet in a locked workbook

    Administrative Note:

    Welcome to the forum.

    Although we value your privacy as much you do, it could be important that members have a rough idea of your location as the solutions they offer may be affected by your locale. For instance, you might in the future post questions which are related to your regional settings.

    With this in mind, please update your profile to something more precise (something such as UK, Europe, USA, UAE, etc. will suffice).

    In the version field, please fill in your current version of Excel.

    Thank you for helping us to help you.

    I have amended your title to better summarise your question.
    Last edited by AliGW; 07-04-2020 at 04:35 AM.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

+ 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. Unlocked sheet in a locked workbook
    By MagnusNovak in forum Excel General
    Replies: 6
    Last Post: 05-11-2020, 10:45 PM
  2. Locked sheet with unlocked cells Spell Check Macro
    By jodi roy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-15-2014, 03:40 PM
  3. Macro, copy UNLOCKED cell range of sheet in open workbook to workbook template
    By NicksDad in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-31-2012, 11:18 AM
  4. [SOLVED] Protecting every sheet and not allowing to select locked or unlocked cells
    By doubl3d80 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-25-2012, 12:42 PM
  5. Highlighting Locked/Unlocked Cells
    By jderren in forum Excel General
    Replies: 2
    Last Post: 10-04-2010, 03:26 PM
  6. When protecting workbook with pw, unlocked cells are still locked
    By Launchnet in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-18-2009, 12:52 AM
  7. Searching for locked/unlocked cells
    By Karthik Bhat - Bangalore in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-15-2005, 11:05 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