I have set up a workbook with a number of sheets that requires entries to be made via command buttons on a specific sheet. I do not want the user to be able to change data in the sheets without using the command buttons. I have therefore protected the relevant sheets (locked). When the user tries to input data in a locked cell the usual "this cell is protected......." message appears as one would expect. However, I want to display a more useful message that directs the user to the sheet with the command buttons. Can anyone help me with the VBA code to do this?
Bookmarks