password problem

[Murat]

Hi all

I created a page asking password, my first problem is that if you disable
macro and start workbook you can enter the other sheets ? Is there a way
to prevent sheet tabs from appearing?

Thanx

Murat Demir Hekimoðlu

 

[Frank Kabel]

Hi
one way:
- hide all other sheets and protect the workbook
- within yopur password asking macro unhide the sheets and
unprotect the workbook
- in the workbook_close event of your workbook hide and
protect the workbook again <and save it

This way the workbook is not accessible without macros