View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default 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/
.