Posts by JimmyB

    Hey Carim, Thanks for your help. I will be assessing all of my macros to determine; (Multiple cell ranges as Selection) and (Single cell ranges as ActiveCell.) . Going forward I'll be using the proper designations. The program works well, so the fix will be prioritized as last though LOL.
    Do you agree with the method of using userinterface code in conjunction with the 3 step protect method where applicable?
    I value your opinion.Thanks Jimmy

    Hi Roy. Thanks for your help but this method locks everything up (near as I can figure) weather the cells are locked or unlocked. I need the versatility, to have appropriate individual cells on various sheets unlocked, as the patient will be inputting data in some of them. So I appreciate your help, but will use the Unlock; Input; Lock method that Carim, has offered. Perhaps to reduce the likelihood of the problem, that you had previously mentioned regarding the error occurrence, I could use this on individual sheets that are not altered...such as the charts. If it wouldn't be too much trouble could you change the code to signify current worksheet only? Very Much appreciated...Jimmy

    Well Carim I'm pretty good at Excel, but am new to VBA. I've had some training in Basic (many years back), which I must admit, helps me today as I do understand the concepts and lingo of programming. Recently I've been learning VBA through the painful process of hunting down examples from the net and applying them to build my macros. In the last 3 or 4 months I've struggled through, and successfully created a program that links about 25 sheets including 14 charts, which all finally work great. Now of late, I'm targeting the syntax that I've not been able to figure out on my own; so I thought that this forum would be the way to go...I was right. you've advised, I'm including a copy of one of my simpler macros (kind of long & structured like an amateur (me)). You've shown me the difference between a selection and active cell but I haven't yet cleaned that part up. I do include REM statements throughout my macros.
    I'm drawing data from my Home Sheet and static (mins & maxs) from my Default Sheet. I'm inputting them into a table in Weight Data Sheet, which in turn populates a chart I want to write to my table in Weight Data Sheet and copy data from my Default Sheet...both protected.
    Please excuse the syntax faux pas :thanx: (Pointers are welcome)

    Hi Carim. That sounds easy. I can live with that.
    Someone else responded with the code:
    ActiveSheet.Protect "", userinterfaceonly:=True [B1] = [A1] I tried this but couldn't get it to work. I tried putting it in my macro and putting it on the no avail. (obviously I did put my password in the quotations). Leaving for the morning and will respond this afternoon when I get back...Thanks...Jimmy

    Looking for code that I can add to my worksheet that:
    When a person inputs data in one unprotected cell, my macro is able to make the necessary calculations and write in the password protected cell. Now It does not write in it, as it is protected. Help will be greatly appreciated. Thanks JImmy

    I need to set a limited amount of rows of data. Struggling with the syntax as it doesn't recognize the first line in my IF statement I'm kind of new to VBA so be gentle.LOL. Here is the code that I've created In Excel 2007

    Sheets("Glucose Data").Select

    'Selects the last cell with data in column A

    ' It jumps over the if/then statement below and goes right to End Sub
    ' Something wrong with my IF statement and can't figure out the syntax
    ' I've tried assigning a variable to the selection & using that in my block to no avail. Spent hours with different variations

    If Selection > Cells(166, 1) Then

    ' At row 166 I want to call the subroutine

    Call RngDel
    Sheets("Home Sheet").Select
    End If
    End Sub