+ Reply to Thread
Results 1 to 5 of 5

Place text if cell is empty

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    08-19-2012
    Location
    Sydney
    MS-Off Ver
    MS Office 365/16
    Posts
    282

    Place text if cell is empty

    Hi all,

    I have text in cell B2 saying - "Click here to pop-up calendar". Because the cell needs to remain unlocked I am afraid people may press the delete button resulting the text to be deleted.

    So what I tried was in C3 i placed a formula - IF(B2="",B2="Click here to pop-up calendar"). Obviously this does not work. Is there a way to keep the text in cell B2 to always appear?

    Thanks.

  2. #2
    Valued Forum Contributor wenqq3's Avatar
    Join Date
    04-01-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    868

    Re: Place text if cell is empty

    Protecting selective cells in Microsoft Excel
    Steps:
    1. Select all of the worksheet (hold down the Ctrl key and A) or all of the working cells in your sheet (hold down the Ctrl, then select Cells).
    2. When the selection has been made, right-click the mouse and select Format Cells from the drop-down window.
    3. Click the Protection tab, deselect the Locked check box, and click OK.
    4. Now click the specific cells that you want to protect. You can select them all at once by holding down the Ctrl button on your keyboard while you click each cell.
    5. Once all cells are selected, right-click the mouse again, go to Format Cells, click the Protection tab, and this time select the Locked check box and click OK.
    6. The final stage is to protect the worksheet. Click Tools, go down the menu to Protection, click Protect Sheet, then click OK. A password is optional here. If you want to password-protect it, enter a password (you will need to reenter it to confirm), then click OK. Don't forget your password because there is no way to retrieve it.
    7. Save your work!!
    -If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".

    -Always upload a workbook before start your question
    To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

    +++ If my answer(s) helped you, please add me reputation by click on * +++

  3. #3
    Forum Contributor
    Join Date
    07-30-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    121

    Re: Place text if cell is empty

    Why not use a form button and record a macro for opening the calendar. then assign the macro to the button.

  4. #4
    Forum Contributor
    Join Date
    08-19-2012
    Location
    Sydney
    MS-Off Ver
    MS Office 365/16
    Posts
    282

    Re: Place text if cell is empty

    I created a macro button. Thanks for that AYData

  5. #5
    Forum Contributor
    Join Date
    07-30-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    121

    Re: Place text if cell is empty

    Can I get an Add Reputation ? pretty please.

+ 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. Replies: 19
    Last Post: 04-10-2013, 08:30 AM
  2. Replies: 2
    Last Post: 02-22-2012, 09:36 AM
  3. [SOLVED] place text in one cell
    By cmmssmith in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-30-2006, 06:10 PM
  4. [SOLVED] Why am I seeing ###### in place of text within the cell?
    By Lindsey in forum Excel General
    Replies: 3
    Last Post: 07-12-2005, 04:05 PM
  5. [SOLVED] place empty cell with zero
    By prince in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-20-2005, 01:06 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