+ Reply to Thread
Results 1 to 2 of 2

Restrict Writing Access To Excel Spreadsheet

  1. #1
    Registered User
    Join Date
    08-17-2012
    Location
    San Luis Obispo, CA
    MS-Off Ver
    Excel 2007
    Posts
    13

    Restrict Writing Access To Excel Spreadsheet

    Hello,

    I currently have a macro-enabled excel workbook, and I have it where a user can input data from a form. Currently the user can view where the data goes, and manipulate the data.

    Is there a way to make the "Data" spreadsheet viewable only, but allowing the user to input data from the form?

    Thanks for the help!

    ~Saucey

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,101

    Re: Restrict Writing Access To Excel Spreadsheet

    Hi, saucey,

    there is no safe way in Excel (sad enough). You could protect the worksheet and let macros fill in but you have to set this on every opening of the workbook:

    Please Login or Register  to view this content.
    goes into ThisWorkbook and should be executed each time the workbook is opened. Please change the name of the worksheet accordingly.

    HTH
    Holger

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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