+ Reply to Thread
Results 1 to 3 of 3

Using a cell but not beeing able to write in it

  1. #1
    Registered User
    Join Date
    02-21-2019
    Location
    Germany
    MS-Off Ver
    2016
    Posts
    1

    Using a cell but not beeing able to write in it

    Hello guys,

    sorry if this question was beeing posted already but I really couldnt find it anywhere.
    I used a code, where I added two numbers in diffrent cells and in a third one i recieve the answer.
    Now I want that noone would be able to write anything into the third cell so you can always see the result of the equation without it beeing manipulated.
    The Problem is that if I try to block the cell in the menu bar then the code doesnt work because it has no Access to the cell aswell and it cant put the answer in there.
    Im still new to Excel so sorry if this question seems rather simple or stupid.
    Thanks in advance

    Coodeeh

  2. #2
    Forum Contributor
    Join Date
    04-20-2017
    Location
    Portugal
    MS-Off Ver
    2016
    Posts
    118

    Re: Using a cell but not beeing able to write in it

    Right click on the cell and format cell, go to the protection tab and uncheck "Locked".

    Now if you protect your sheet the code can make changes to that cell.

  3. #3
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,137

    Re: Using a cell but not beeing able to write in it

    1. Select the developer tab.

    Start your Macro Recorder

    Select your cell with the formula

    Click into the formula bar at the top of excel and then press enter.

    Stop the Macro Recorder.

    2. Select the developer tab
    Select run Maco
    Select Macro1 and the EDIT.

    You should see something like:

    Please Login or Register  to view this content.

    Edit that code to something like:

    Please Login or Register  to view this content.
    Copy that code and close the Macro Module.

    Right Click on the Sheet Name at the bottom of excel and select view code

    A module will open.

    Select the Listbox at the top left that Says General. Make that read Worksheet.

    Select the Listbox at the top Right that Says SelectionChange. Make that read Change.

    You will see this code:

    Please Login or Register  to view this content.

    Paste your Macro in the middle of that code and then close the Module:


    Please Login or Register  to view this content.

    Ok you are done. From Now on it is impossible to change the formula in your cell.
    My Rules if you want my help:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

+ 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. [SOLVED] Write Sub procedure to format excel and write case/if statement to text file
    By vbronton in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-06-2018, 08:26 AM
  2. Replies: 4
    Last Post: 12-03-2016, 06:33 AM
  3. Find cell with text, offset to the left one cell and write code
    By timas in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-23-2015, 01:22 AM
  4. Replies: 1
    Last Post: 04-19-2013, 12:44 AM
  5. [SOLVED] Code to evaluate contents of one cell then write new values into new cell (Simple IF Stmt)
    By clemsoncooz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-05-2012, 11:54 AM
  6. Replies: 2
    Last Post: 02-17-2012, 03:08 AM
  7. Replies: 2
    Last Post: 10-27-2011, 05:30 AM

Tags for this Thread

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