+ Reply to Thread
Results 1 to 2 of 2

Issues with using unlocked cells in a large scale?

  1. #1
    Registered User
    Join Date
    03-26-2015
    Location
    Netherlands
    MS-Off Ver
    2013
    Posts
    75

    Issues with using unlocked cells in a large scale?

    Hello,

    I'm making a small tool for end users and to ensure nothing gets altered that shouldnt get altered I have the following code in place:

    ActiveSheet.Protect Password:="test", userinterfaceonly:=True, AllowFiltering:=True
    ActiveSheet.EnableSelection = xlUnlockedCells
    Now there is one slide where users will add thousands of rows of data over time.
    Each time a row o data is added the range of the row is unlocked using the following code:

    Range(Cells(NewRow, StartColumn), Cells(NewRow, EndColumn)).Locked = False
    This means the user will be able to alter the actual data within the tool freely without affecting anything else.

    However, I'm a bit fearful to use 'unlocked cells' in combination with 'protected sheets'. I suspect this was the cause of corrupted files I have had in the past.
    I already noticed that the file size increased when 2000 rows of data became 'unlocked'.

    Anybody else have experience with this kind of code (good or bad) and perhaps any advice on what to do and what not to do?

  2. #2
    Forum Contributor
    Join Date
    07-23-2016
    Location
    Texas
    MS-Off Ver
    2016
    Posts
    273

    Re: Issues with using unlocked cells in a large scale?

    Why not have the user enter the date in a dummy workbook or a user form then when they have all the data entered, have a save button and in VBA code, unprotect the worksheet, update the row data, then protect the worksheet.

+ 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. Replies: 5
    Last Post: 03-31-2015, 03:38 AM
  2. Using Randbetween on a large scale
    By ryanch69 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-31-2014, 06:31 AM
  3. [SOLVED] XML Import on large scale
    By jaromluker in forum Excel General
    Replies: 9
    Last Post: 06-12-2014, 02:46 PM
  4. Large scale counting
    By rhoknee in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-12-2010, 05:17 PM
  5. Issues with the scale of a graph
    By dante19 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-04-2009, 03:42 PM
  6. Large scale summation using Excel for Mac
    By SAP2112 in forum Excel General
    Replies: 1
    Last Post: 12-12-2008, 05:40 PM
  7. Moving from unlocked cells to unlocked cells in an excel form
    By Stacey Lee in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-24-2006, 03:50 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