This is a really silly question, by comparison to others. However, Is it possible to protect a whole folder (i.e. with 1 password) rather than having to protect every file within it!!
are you running on Windows NT? If you are you can restrict access to the folder on the basis of user.
Yes, am running Windows NT. How exactly would I do that?
There are currently a hundred or so people who can access; would like them just to have read-only access, and to require a password if changes are to be made!
_________________
LASW10
If you are running these folders on a network drive then chances are that you will need to speak to the administrator about setting viewing priveleges. To check your own security level - highlight the folder you wish to password protect and right click, choose properties and then go to permissions & security and tell us what you see or what message you get.
Yes, am running Windows NT. How exactly would I do that?
There are currently a hundred or so people who can access; would like them just to have read-only access, and to require a password if changes are to be made!
First of all you will need to have the correct security level to be able to change the access. (if not your NT Admin)
In Windows Explorer select the folder, Right Click and select Properties,
Next Click the Security tab
Click The add button and select the people from the list who should have access then check the relevant access levels.
In most companies IT departments put people in groups ie Finance will contain all people in that department so you can add the group names check with your NT admin if this is the case.
Regarding the last part part, if you want to have password access for any changes, this will require setting at the every file level as it is an application setting whereas the others are all Windows.
However you can write a macro to password protect all files in a folder... I'll Start looking at this but in the meantime you have the first part.
Edit : Sorry Work has got in the way...Probably better to post a new message asking for how to do this...
Macro using the application.filesearch and then looping through each of the foundfiles object
Sorry can't do more...
_________________
Hope This Helps.
Sean.
Win98, XL2000 This message was edited by s-o-s on 2002-10-21 09:19
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.