Arvi

Thanks for the update on this.

Was not thinking about setting the sheet to veryhidden in this manner.

Good advice and an easy method once explained as you have.

Was me who misunderstood your original post.

I just keep on learnin'


Gord

On Fri, 1 Apr 2005 08:11:10 +0300, "Arvi Laanemets" wrote:

Hi Dord

Actually no VBA code was meaned. In VBA-Project window you can set
properties for every sheet manually too. Protecting after that the project
(having any code or any module at all in VBA-project isn't essential)
prevents further access to whole project - properties window (lower left one
when activated) included.

To set any properties manually, you must have Properties window activated -
when not then activate it from View menu. Then in VBA-Project window select
the sheet, and in properties window set the properties for selected sheet.
When ready, right-click on VBA-Project object in VBA-Project window, select
VBA-Project Properties and then Security, and set the password.