VBA Conversion Question

[JHaugh]

Not sure if this is the right section or even the right forum for this question but I hope someone here can help. I am in the process of moving a very useful Excel document that I created to Google Doc's. The problem is that it is useful because of the VBA Macros that I have built in it and of course Google doesn't use VBA Script.

I believe it's possible to convert them all to javascript and not lose any functionality but I don't know if anyone on these boards knows anything about javascript or where I could go to find out more info. Here is an example of one of the scripts I use

Private Sub ToggleButton1_Click()    ActiveSheet.Unprotect
    If ToggleButton1.Value = True Then
        For i = 1 To Range("SName").Rows.Count
            For j = 1 To Range("SName").Columns.Count
                With Range("SName").Item(i, j)
                    If .Value = 0 And .Value <> "" Then
                        .EntireRow.Hidden = True    'hide row
                        Exit For    'next row
                    End If
                End With
            Next j      'next col
        Next i          'next row
    Else    'toggle is false
        ' Unhide all rows in range
        Range("SName").EntireRow.Hidden = False
    End If
    ActiveSheet.Protect
End Sub

I'm just not used to javascript unfortunately.

 

[XLfriend777]

Hi JHaugh - I too want to write macros in Google docs and have done a little investigation. I did find this tutorial, which looks helpful, although I'm sorry I have not had time to play with it yet.

Hope this helps.

https://developers.google.com/apps-script/quickstart/macros

All the best,

Happy Excelling ,

goesr

 

[JHaugh]

Thanks goesr I will take a look at it today.