+ Reply to Thread
Results 1 to 2 of 2

Adding Security To A Form

  1. #1
    Registered User
    Join Date
    02-10-2016
    Location
    Wichita, KS
    MS-Off Ver
    365
    Posts
    2

    Adding Security To A Form

    I have reformatted a form that is used to assess risk. This form has historically been used with no security in place, and as a result, the original form was subjected to unauthorized edits and saved with different information in the form. What I'd like to do is lock all but certain cells (into which data will be placed) and place some protection that would not allow the file to be saved except in PDF format. I have no idea how to proceed with this; I'd truly appreciate some help from those who know.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,734

    Re: Adding Security To A Form

    I assume you are talking about Excel (posted to Outlook subforum).

    Locking the cells is straightforward with built-in features, but if you want to restrict saving then it requires VBA. However, this can be defeated simply by not enabling VBA to run. You may want to consider making the file read-only at the Windows level so it cannot be saved.

    The VBA would capture the Save event and prevent the file from being saved. It could also force a save to PDF if this is attempted. However, you will still need a way to save it if the form itself needs to be changed.

    Let us know if this sounds consistent with your requirements.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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. VBA code for adding security features to Outlook attachments (watermarking,encryption etc)
    By Pankaj jaswani in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-18-2023, 02:24 AM
  2. [SOLVED] Excel Form (not adding new rows... but linking form objects to same cells)
    By skydivetom in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-02-2022, 04:55 AM
  3. Form Controls broken by December 2014 security updates
    By Olly in forum Tips and Tutorials
    Replies: 1
    Last Post: 12-15-2014, 07:14 PM
  4. placing a security protection on table, form, query or macro in MS Access
    By nataliem in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-24-2007, 09:40 PM
  5. [SOLVED] Form Button Security
    By Paul Black in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-16-2006, 10:10 AM
  6. Form Security
    By elyse in forum Excel General
    Replies: 0
    Last Post: 07-03-2006, 09:45 AM

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