Show unlocked cells in protected sheet

[Aerowolf]

I have a spreadsheet that is protected with several unlocked cells. Is there a way to show/highlight the unlocked cells so it is obvious to the user which cells he can access? I don't want any colors or shading to show up on the printout.

Thanks

Edwin

 

[bandit600]

Depending how unsightly you are prepared to have it look. A very crude way, but immediately obvious, would if you have space next to the unlocked cells, be to add an autoshape and text box from the drawing toolbar. I would suggest an arrow or }. Whichever you add together with the text box can be made non printable. Right click, choose format autoshape/text box, click on the properties tab and take the tick out of print object. Add colour to each if required.

You will need to unprotect the sheet before you do this and then protect again after.

Bandit600

 

[kadam]

How about using Comments?

Add the Comment, right click and select Show Comment.

On the Page Setup, under Print, Sheet, just make sure the selection for Comments is <None>. You can now make them look nice on screen and not have them print.

Kadam.

 

[combo]

You can allow user to select only unprotected cells via macro, for instance automacro for Sheet1 (code name here):

[tt]Private Sub Workbook_Open()
Sheet1.EnableSelection = xlUnlockedCells
End Sub[/tt]

Unfortunately, this worksheet property is not saved, so must be fired every time workbook one opens workbook.