Hi,

Is it possible to run a macro from a button to password protect a file?
and similarly is it possible to remove the password protection from a button?

thankyou for your help.

Patrick,

you can do something like this.

'Protect/Unprotect a sheet
Worksheets("Sheet1").Protect Password:="password"
Worksheets("Sheet1").Unprotect Password:="password"

'Protect/Unprotect the active workbook
ActiveWorkbook.Protect Password:="password"
ActiveWorkbook.Unprotect Password:="password"


Lookup the Protect and Unprotect methods in the VBA help for more details on
the available parameters.


--
Hope that helps.

Vergel Adriano


"Patrick Bateman" wrote:

Hi,

Is it possible to run a macro from a button to password protect a file?
and similarly is it possible to remove the password protection from a button?

thankyou for your help.

On 28 Aug, 16:46, Vergel Adriano
wrote:
Patrick,

you can do something like this.

'Protect/Unprotect a sheet
Worksheets("Sheet1").Protect Password:="password"
Worksheets("Sheet1").Unprotect Password:="password"

'Protect/Unprotect the active workbook
ActiveWorkbook.Protect Password:="password"
ActiveWorkbook.Unprotect Password:="password"

Lookup the Protect and Unprotect methods in the VBA help for more details on
the available parameters.

--
Hope that helps.

Vergel Adriano



"Patrick Bateman" wrote:
Hi,

Is it possible to run a macro from a button to password protect a file?
and similarly is it possible to remove the password protection from a button?

thankyou for your help.- Hide quoted text -

- Show quoted text -

might also be worth mentioning that it's PROBABLY sensible to password
protect your code as IF the reason for the protection unprotection is
to keep the password secret, all the user needs to do with unprotected
code is view it to find out what the password is.

Thankyou for you help much appreciated

" wrote:

On 28 Aug, 16:46, Vergel Adriano
wrote:
Patrick,

you can do something like this.

'Protect/Unprotect a sheet
Worksheets("Sheet1").Protect Password:="password"
Worksheets("Sheet1").Unprotect Password:="password"

'Protect/Unprotect the active workbook
ActiveWorkbook.Protect Password:="password"
ActiveWorkbook.Unprotect Password:="password"

Lookup the Protect and Unprotect methods in the VBA help for more details on
the available parameters.

--
Hope that helps.

Vergel Adriano



"Patrick Bateman" wrote:
Hi,

Is it possible to run a macro from a button to password protect a file?
and similarly is it possible to remove the password protection from a button?

thankyou for your help.- Hide quoted text -

- Show quoted text -

might also be worth mentioning that it's PROBABLY sensible to password
protect your code as IF the reason for the protection unprotection is
to keep the password secret, all the user needs to do with unprotected
code is view it to find out what the password is.