protect workbook

[Guest]

Hi,

I would like to protect the structure of a workbook.

I have tried

ActiveWorkbook.Protect Password:=pword, Structure:=False
ActiveWorkbook.Protect (pword, True)

(where pword is a variable defined earlier)
and various other combinations.
I get a compile error in all cases - "Expected: ="

What am I doing wrong?

Eugene

 

[Guest]

Problem solved.

My password variable was a number which was not being accepted by
Activeworkbook.Protect. Changed it to a string using Cstr(pword) and it works.

Strange thing is that I used the same logic and commands to protect the
sheets in the workbook. ActiveSheet.Protect Password:=pword works when the
pword is an integer or other number.

Quite quirky if you ask me.

Eugene