-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
I need to put a password for a VBA code
- Thread starter gaftalik
- Start date
Excel Facts
VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
Hi, I've got the same issue, box ticked, saved and closed but it doesn't work ? I've got it to work on a xlsm file, but when trying to do it on a xlsx it wont remember passwords. Does anyone know if certain files wont work, or which files will except xlsm's ? When i email files i dont want to use xlsm as this might scare customers.
Thanks for your inputs
Thanks for your inputs
Upvote
0
RoryA
MrExcel MVP, Moderator
- Joined
- May 2, 2008
- Messages
- 43,209
- Office Version
- 365
- Platform
- Windows
- MacOS
It will not work (2007 onwards) in a file that doesn't actually contain code. So you can no longer for example set a worksheet to veryhidden and then protect the project. There has to be code (or vbcomponents).
Upvote
0
Thanks Ruddles & Rorya
I did wonder if it was a format issue, but as i didn't have to manually add any code to the xlsm file to protect it i presumed it should (in theory) be able to password protect any MS file.
The reason to protect the file was to "Very Hide" some sheets and lock them as they have confidential info in them.
Thanks again
Ant
I did wonder if it was a format issue, but as i didn't have to manually add any code to the xlsm file to protect it i presumed it should (in theory) be able to password protect any MS file.
The reason to protect the file was to "Very Hide" some sheets and lock them as they have confidential info in them.
Thanks again
Ant
Upvote
0
