Creating undeletable characters in Excel 2013

[Dark91zc]

Hello. I have an excel spread sheet that I would like to have two * turned into undeletable characters. So that when you click on a cell the cursor is in the middle of the *'s. I also would like if those characters can not be delete by highlighting or backspace. Is this possible? Thanks.

 

[XLfriend777]

Hi Dark91zc - You might consider putting each * in a cell by itself and then protecting the cell so that it can be edited. You could then have a cell, between the stars, that could be edited. Just a thought to hopefully get this thread going.

 

[Dark91zc]

Thanks Goesr. My coworker found some vba codes but I am trying to figure out how to apply the cell function or formula into the macro. The application would be hard because every time a button on the user form is clicked the information is put on a Main worksheet and pasted to a new work sheet that is opened. The new sheet that is created is going to be print out with the information in barcode format. The * are used so the program that we use can auto index the names and Date of Birth.

 

[XLfriend777]

Another feeble attempt. You might try using a custom format which puts a * on the front and end of the cell and those can't be edited. Something like custom format of: "*"??"*" just a thought.

 

[Dark91zc]

I was Looking at ="*"&cell&"*" but when I have that in the vba I get errors on it. The original workbook I am working from the guy had all of the sheets labeled and setup using =Sheet!Column,Row (=DATA!B4). If I could figure out how to combined those two I would be happy. Also I am still learning VBA. Don't have much time at work yet they want me to do the macros because of my vision of making things work.

Thanks for the help. If need be I can make a link of both codes.