+ Reply to Thread
Results 1 to 2 of 2

Restrict Writing Access To Excel Spreadsheet

  1. #1
    Registered User
    Join Date
    San Luis Obispo, CA
    MS-Off Ver
    Excel 2007

    Restrict Writing Access To Excel Spreadsheet


    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!


  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    Hamburg, Germany
    MS-Off Ver
    2019 on Win10 (desktop), 2019 on Win11 (notebook)

    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.


+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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