Read only access for hidden sheet

[kashyap]

Hi, I have a workbook with several sheets for different users (shared) with
different passwords for each sheet

I have all these sheets hidden and hyperlink to each sheet on a opening sheet.

I need to give users, read only access to other's sheet (which will open on
demand with the help of hyperlink again)

Actually I need all the sheets to be read only.. once they click on the
hyper link to open a particular sheet, it should ask for password and if
password is not entered, then it should open as read only..

any help pls

Thanks..

 

[silkfire]

Use:

SetAttr "C:\Shared.xls", vbReadOnly

 

[kashyap]

No, file should have read write access, but sheets should be read only until password is entered..