-1

Can anyone help me to convert the following VB script to Google script.

Sub ShowPass()

UserForm1.Show

End Sub

Sub ResetSIG()
Dim pwd As String

' Turn off application events to prevent problems with the page updating
Application.EnableEvents = False

' Get the SIG password
pwd = ActiveWorkbook.Worksheets("Drops").Range("A17").Value

' Reset all of the tabs to their default
Application.Run "Module2.ColHide", pwd

' And password protect the sheets
Application.Run "module2.ProtectOnly", pwd

'Move to the Scoping tab
ActiveWorkbook.Worksheets(4).Select

' Turn application events back on
Application.EnableEvents = True


End Sub

Sub ScopingPWProtect()

PWPass1.Show

End Sub

Sub ShowPass()

UserForm1.Show

End Sub

Sub ResetSIG()
Dim pwd As String

' Turn off application events to prevent problems with the page updating
Application.EnableEvents = False

' Get the SIG password
pwd = ActiveWorkbook.Worksheets("Drops").Range("A17").Value

' Reset all of the tabs to their default
Application.Run "Module2.ColHide", pwd

' And password protect the sheets
Application.Run "module2.ProtectOnly", pwd

'Move to the Scoping tab
ActiveWorkbook.Worksheets(4).Select

' Turn application events back on
Application.EnableEvents = True


End Sub

Sub ScopingPWProtect()

PWPass1.Show

End Sub
New contributor
user205880 is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.

closed as too broad by ale, jonsca Jan 10 at 1:44

Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • What have you tried so far, have you generated any code? BTW, it might be helpful for you to try duplicating the steps while "record macro" is on. Also, we don't know what UserForm1 or PWPass1 is. – Tyler Gubala Jan 9 at 15:04