Posts by stu@gener8

    Re: Removing ability to delete comments in excel

    [QUOTE=skywriter;772594]Check out this thread.

    Thanks Bruce. I went and copied the code in Thread #9 and attached the code to the sheet I was wanting it actioned in. Ran the Macro and it didn't make any difference. I was still able to delete a comment.

    I don't know if I'm missing something here or my lack of VB knowledge is creating a hurdle here.......


    I want to use comments in a spreadsheet to record changes to values in a variety of cells so am looking to remove the ability to delete any comments, so that the history of the changes remain. I've gone on line and searched and found the following code:

    Sub nocomments() 
        CommandBars("Worksheet Menu Bar").Controls("Insert").Controls("Comment").Enabled = False 
        CommandBars("Worksheet Menu Bar").Controls("Edit").Controls("Clear").Controls("Comments").Enabled = False 
    End Sub

    which then became

    CommandBars("Cell").Controls("Edit Comment").Enabled = False 
    CommandBars("Cell").Controls("Delete Comment").Enabled = False

    so I thought I could just remove the first line of the code, but this isn't working. I'm getting the following error:

    [FONT=&quot]Can't execute code in break mode

    then its - Invalid outside parameter.

    I'm not skilled enough to know how to sort so Can what I want be done and if so - what is the code required. Thanks[/FONT]