Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Password Problem | Excel Discussion (Misc queries) | |||
password problem | New Users to Excel | |||
Password Problem | Excel Discussion (Misc queries) | |||
I have a password problem | Excel Worksheet Functions | |||
Problem due to password | Excel Programming |