943,660 Members | Top Members by Rank

Hardware and Software > Microsoft Windows > Windows Software > VBA -- file permissions
Ad: Download a FREE TFTP Server Tool for Network Configuration from Spiceworks
Permalink
Jun 17th, 2009
0

VBA -- file permissions

Expand Post »
Okay so I am new to programming but I have a very basic knowledge of some things. I have been working with vba and I need to write a macro for a word document that only allows the people that are allowed into it to view it and I havent the foggiest idea on how to do that. Does anyone have any ideas or possibly a saved macro that they have used in the past that I might be able to use?
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
archangel1177 is offline Offline
3 posts
since Jun 2009
Permalink
Jun 17th, 2009
0

Re: New guy here!

cant you just password protect the file ?
Reputation Points: 24
Solved Threads: 33
Posting Whiz in Training
HITMANOF44th is offline Offline
283 posts
since Apr 2009
Permalink
Jun 17th, 2009
0

Re: New guy here!

because i know in word you can set passwords for files so only if you know the password you can view edit that file
Reputation Points: 24
Solved Threads: 33
Posting Whiz in Training
HITMANOF44th is offline Offline
283 posts
since Apr 2009
Permalink
Jun 18th, 2009
0

Re: New guy here!

Sure I could do that, But what I am looking for is to make it to where there are logins for the few people that are going to be able to view it. What I have it a document that has a rotating list of passwords for the production machinery that needs to be kept out of public access, but needs to be on the company network so that all of the people involved can get to it.
Reputation Points: 10
Solved Threads: 0
Newbie Poster
archangel1177 is offline Offline
3 posts
since Jun 2009
Permalink
Jun 18th, 2009
0

Re: New guy here!

I agree, why not just create a folder on the network, chuck the word doc in the folder, and password protect the folder, and only those that know the password, will be able to access the folder.
Featured Poster
Reputation Points: 76
Solved Threads: 86
Senior Poster
Kraai is offline Offline
3,935 posts
since Feb 2008
Permalink
Jun 18th, 2009
0

Re: New guy here!

Yeah you guys are probably right. I think that i was trying to over think the situation. Thanks.
Reputation Points: 10
Solved Threads: 0
Newbie Poster
archangel1177 is offline Offline
3 posts
since Jun 2009
Permalink
Jun 18th, 2009
0

Re: New guy here!

@archangel1177

Keep it simple, that is my motto when it comes to these things. However, I do not know anything about programming, and what you were trying to do, may still have an answer.
Featured Poster
Reputation Points: 76
Solved Threads: 86
Senior Poster
Kraai is offline Offline
3,935 posts
since Feb 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in Windows Software Forum Timeline: Hard Drive Missing
Next Thread in Windows Software Forum Timeline: Error when double clicking MS Office doc... won't open





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC