password problem
 

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

--
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/

password problem
 

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
-----Original Message-----
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

--
Using M2, Opera's revolutionary e-mail client:
http://www.opera.com/m2/
.