Security

rendzina

New Member
Joined
Oct 20, 2002
Messages
9
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!!

Thanks

Rendzina
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

DonkeyOte

MrExcel MVP
Joined
Sep 6, 2002
Messages
9,123
are you running on Windows NT? If you are you can restrict access to the folder on the basis of user.
 

rendzina

New Member
Joined
Oct 20, 2002
Messages
9
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
 

DonkeyOte

MrExcel MVP
Joined
Sep 6, 2002
Messages
9,123
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.
 

s-o-s

Active Member
Joined
Apr 14, 2002
Messages
384
Hi,

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
 

Forum statistics

Threads
1,144,210
Messages
5,723,047
Members
422,476
Latest member
beck85

We've detected that you are using an adblocker.

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.
Go back
Top