+ Reply to Thread
Results 1 to 3 of 3

How to prevent "code inserts" into worksheets?

  1. #1
    Forum Contributor
    Join Date
    10-10-2018
    Location
    Calgary, Canada
    MS-Off Ver
    2016
    Posts
    214

    How to prevent "code inserts" into worksheets?

    So I've created worksheets that record data through user forms.

    The problem is that savvy users can figure out your formulas and code by inserting Excel functions instead of text.

    For example, instead of entering a "Description" they can enter "=Row()" and figure out the row numbers, or any number of functions. How to prevent that other than forcing a " ' " as the first character?

    Thanks!

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: How to prevent "code inserts" into worksheets?

    Quote Originally Posted by superlative View Post
    For example, instead of entering a "Description" they can enter "=Row()" and figure out the row numbers
    Whether this goes from userform or they input directly in worksheet cell?


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Forum Contributor
    Join Date
    10-10-2018
    Location
    Calgary, Canada
    MS-Off Ver
    2016
    Posts
    214

    Re: How to prevent "code inserts" into worksheets?

    correct. If they enter that in the userform. Anyway, I fixed it by writing a Sub that just strips off any spaces or equal signs from the beginning of any text.

+ 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. Prevent "delete row" but allow "clear contents"
    By alreadytaken in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-19-2019, 05:19 AM
  2. [SOLVED] How to prevent "update values" window open when code executes to enter formula in table?
    By carlito2002wgn in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-15-2019, 03:44 PM
  3. [SOLVED] Prevent Duplicate Receipt Number in Three Column [ e.g. Column "A", "B", "C" ]
    By MrsCharmy in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-31-2017, 08:40 AM
  4. [SOLVED] Office 2010 Save inserts "Copy of" in filename
    By amthyst826 in forum Excel General
    Replies: 5
    Last Post: 10-10-2014, 03:28 PM
  5. Replies: 11
    Last Post: 05-17-2013, 06:24 AM
  6. [SOLVED] use variable in Workbooks("book1").Worksheets("sheet1").Range("a1"
    By Luc in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-28-2005, 04:05 PM
  7. Replies: 1
    Last Post: 03-30-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