Prev: Is it possible to include a macro by a macro?
Next: Target Range Activation
From: ordnance1 on 24 Jan 2010 15:55
How can I edit the code below to enter the password snow (I use a password on
the protected sheet to keep people from makeing unwanted changes)

Also I need code to reprotect the worksheet at the end addining the password
snow.

Sub Macro1()
'
' Macro1 Macro
'

'
ActiveSheet.Unprotect
End Sub
From: Mike H on 24 Jan 2010 16:14
Sub Macro1()
ActiveSheet.Unprotect password:="snow"
End Sub

Note snow is case sensitive
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"ordnance1" wrote:

> How can I edit the code below to enter the password snow (I use a password on
> the protected sheet to keep people from makeing unwanted changes)
>
> Also I need code to reprotect the worksheet at the end addining the password
> snow.
>
> Sub Macro1()
> '
> ' Macro1 Macro
> '
>
> '
> ActiveSheet.Unprotect
> End Sub
From: Gord Dibben on 25 Jan 2010 12:59
Sub UnProtect()

ActiveSheet.UnProtect Password:="snow"

Run some code to do things and when complete reprotect

ActiveSheet.Protect Password:="snow"

End Sub


Gord Dibben MS Excel MVP

On Sun, 24 Jan 2010 12:55:04 -0800, ordnance1
<ordnance1(a)discussions.microsoft.com> wrote:

>How can I edit the code below to enter the password snow (I use a password on
>the protected sheet to keep people from makeing unwanted changes)
>
>Also I need code to reprotect the worksheet at the end addining the password
>snow.
>
>Sub Macro1()
>'
>' Macro1 Macro
>'
>
>'
> ActiveSheet.Unprotect
>End Sub

 | 
Pages: 1
Prev: Is it possible to include a macro by a macro?
Next: Target Range Activation