Hidden field with text, number, to show there is something in field

Hi all,

new to this forum

Basically we work with excell spreadsheets a lot when it comes to paying employees

this is done by our staff at the moment there inst much privacy when it comes to displaying salaries wage etc in each cell

what i have come across recently is the right click, format cells, custom and then 3*;.....this is all well and good but in a very large spreadsheet it is possible (even if it is evenly spaced out in rows and column) to forget which cells you have hidden etc, now to work around i was thinking what if the cell had a number 1 in there or a hashtag, or something still insignificant to the eye but once its clicked on you can see the true value of the cell in the formula bar.

i understand we will not be able to do this via excell standard functions however if there is some VBA anyone can help me with that would be really helpful

Thanks

Bilal

Sorry for the stupid question but is that a macro, formula or vba?

Also do i have to use them both together or can i just use one of them

ive created a maqcro called test and put both pieces of code, first one first and second one next i.e. before close and open

im getting an error; the following features cannot be saved in macro free workbooks; VB Project .....

and its basically telling me to save the file using macro enabled file types..

what would the file type be

Ive added an attachment, this is a test im trying to get it to work on, is it possible when youre free that you get it to work so that the 87's you see get replaced with a symbol until theyre clicked on.

Thanks

Warm regards

Bilal

Also does, 'ThisWorkbook.Worksheets' need to be changed to the name of my file?

Ok ive put it into 'thisworkbook' on the top left of the coding window under VBA projects

and ive also changed the range from "e1-e4" because thats what i want to test on.

I've saved it, tried running the macro, but nothing

Should there be some kind of onclick event also?

Ahhh it works,however the same problem still stands, the field is still empty i would like the field to have a symbol, character, or a hashtag until i click on it which will then in turn show me the true value in the field.

Thanks again