I want to create an excel file for every cost centre in my organisation
Each file will have a unique password that is known by the cost centre manager (and myself obviously)
My question is - can I have an additional password that only I know or a few people know that can open any of them?
So each file would have 2 passwords, where one is a 'master' password that opens all the files.
I have Excel 2007.
Many thanks
David
See if this does it for you
http://www.excelforum.com/excel-gene...readsheet.html
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Please click the * Add Reputation if this helps
If solved remember to mark Thread as solved
"I'm glad to help and this is not meant to sound smart, but either you have super-human vision to see all those controls cleared one by one with the code I posted, or your computer is really slow."
Thank you both for replying. Correct me if I am wrong - it seems that you cannot set multiple passwords to 'open' a spreadsheet, but rather you can write code to get the user to enter a password after opening the file and that VBA code dictates what they can access?
Do you know what happens if the user does not have macros enabled?
Did you check the file on the link that I give you?
Could you just answer the question?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
If you don't enable macros, then any VBA will not work in a spreadsheet.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks