ExcelBanter - Unprotect in a macro

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Unprotect in a macro (https://www.excelbanter.com/excel-discussion-misc-queries/205058-unprotect-macro.html)

Partly Void[_2_]

Unprotect in a macro

Is it possible to hide a protection password in a macro

Mike H

Unprotect in a macro

see your other thread

"Partly Void" wrote:

Is it possible to hide a protection password in a macro

Gord Dibben

Unprotect in a macro

Yes.

You must lock the project from viewing.

In VBE right-click the workbook/project and PropertiesProtection.

Check the lock from viewing and add a password.

The workbook must be saved and closed before protection of code takes place.

Gord Dibben MS Excel MVP

On Sat, 4 Oct 2008 01:31:01 -0700, Partly Void
wrote:

Is it possible to hide a protection password in a macro

Partly Void[_2_]

Unprotect in a macro

Thanks Gord,

"Gord Dibben" wrote:

Yes.

You must lock the project from viewing.

In VBE right-click the workbook/project and PropertiesProtection.

Check the lock from viewing and add a password.

The workbook must be saved and closed before protection of code takes place.

Gord Dibben MS Excel MVP

On Sat, 4 Oct 2008 01:31:01 -0700, Partly Void
wrote:

Is it possible to hide a protection password in a macro

All times are GMT +1. The time now is 07:00 PM.