On Friday, January 25, 2013 10:22:32 PM UTC-8, Robert Crandal wrote:
After data is saved in our spreadsheet each day, we usually mark

both the spreadsheet and workbook as password "protected".

This prevents users from changing data on our spreadsheets.



The problem is, sometimes we have string data that exceeds the

width of cells, which hides most of the string in that cell. Are there any

methods to allow a user to view the complete string in the above type

of scenario?? If the user double clicks on a string cell can I just display

that string in MsgBox or something?? Any other ideas?



Thank you!



Robert

Hi Robert,
Maybe something like this where all you have to do is select the a cell.

Option Explicit

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim x As String
x = ActiveCell.Value
If x = "" Then Exit Sub
MsgBox x
End Sub

Regards,
Howard