I have built an application in which only cells for input data can be changed by the user. The file opens with a graphic display and then a series of toolbars allows access to the particular regions of the worksheets for data input, handling and final calculation.

My problem is that if the mouse button is clicked inadvertently the EXCEL error userform appears with the message that the sheet is protected and cannot be changed. On clicking OK the display jumps to exhibit cell IV1 selected and it is necessary to close and reopen the file to return to proper operation.

This problem occurs with both

ActiveSheet.Protection = xlUnLocked and

ActiveSheet.Protection = xlNoRestriction

options acting on the protected worksheet, cell IV1 being locked at all times.

My problem with file size is that it seems to be a random variable. Deletion of VBA code does not seem to have a direct bearing on the size of my EXCEL file.