+ Reply to Thread
Results 1 to 3 of 3

Lock a worksheet, but let rfid scanner write in it

  1. #1
    Forum Contributor
    Join Date
    04-20-2017
    Location
    SWEDEN
    MS-Off Ver
    2016
    Posts
    123

    Lock a worksheet, but let rfid scanner write in it

    I've got a worksheet, I've got a rfid scanner connected that should be able to scan cards - but I dont want anyone to manually write in it - is it possible to lock it like that?

  2. #2
    Forum Expert
    Join Date
    10-02-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    1,222

    Re: Lock a worksheet, but let rfid scanner write in it

    The only way this or something like it would be possible is via a macro. essentially it would unlock the sheet, write information and lock when the macro is triggered. In my opinion not a very good way to go about it. You would be better off simply unlocking it manually, scanning stuff and locking it at the end when complete.
    Ways to get help: Post clear questions, explain your overall goal, supply as much background as possible, respond to questions asked of you by those trying to help and post sample(s) files.

    "I am here to help, not do it for people" -Me

  3. #3
    Valued Forum Contributor
    Join Date
    03-16-2017
    Location
    UK
    MS-Off Ver
    2016
    Posts
    371

    Re: Lock a worksheet, but let rfid scanner write in it

    In my experience scanners that write to Excel are doing exactly the same as if you were to type it in manually. Think of the scanner as another keyboard. I don't think that there is any way to distinguish between the two.
    Design everything to be as simple as possible, but no simpler.

+ 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. RFID card data base
    By Ross85 in forum Excel General
    Replies: 2
    Last Post: 09-28-2017, 08:50 PM
  2. Excel to read RFID scanner COM Port and look up for database
    By aeonfulx in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-17-2016, 09:34 AM
  3. Using RFID reader to populate attendance roster for training events
    By kojorobe in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-05-2015, 11:57 PM
  4. Urgent help needed with VBA in excel for barcode scanner worksheet
    By drowe005 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-02-2015, 10:31 PM
  5. Barcode Scanner - The cursor jumps a row in a Microsoft Excel worksheet.
    By Looser008 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-16-2014, 10:37 PM
  6. RFID Time and date stamp on scan
    By surfershort in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-27-2014, 02:57 PM
  7. Can I lock cells or do I have to lock the worksheet?
    By jmbtexas in forum Excel General
    Replies: 4
    Last Post: 11-11-2008, 02:26 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