Hi
I have an issue with my spread sheet that I can't seam to resolve. I have a VBA formula the created a drop down that I can do a multiple select for the cell. It works perfect when the sheet is unlocked, but when I protect it the work sheet the drop down cell won't let me select multiple choices. Would anyone have any idea on how I could resolve this.
Thanks in advance for any advice.
Hi, Treecko,
have you unlocked the cell prior to applying Protection?
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Hi Thanks for the reply, Yes the cells in the column are unlocked, This is what's got me so confused about it.
Hi, Treecko,
would it be possible to post the workbook as an attachment? We might find the reason for the strange behaviour if we could have a closer look at it.
Ciao,
Holger
Hi HaHoBe
Thanks for the reply again. I uploaded a sheet and if you have issuse with the pass word, it is "protect"
Good luck and thanks for looking at it
Sorry forgot to mention column L is the drop down that multiple codes can be checked. I tried also adding a code in VB but it seems to kck back out when I close and open the file again. It asked for the password to start again. I'd like to try and avoid it as I would be send the sheets out and not really want to provide them with the pass word
Hi, Treecko,
no luck with the mentioned password for me.
You should protect the worksheet on opening the workbook or on activating the sheet as UserInterfaceOnly is volatile and will not be saved with the workbook.
Ciao,
Holger
Sorry HaHobe
I appreciate you sticking with this and me not uploading the file correctly. I re uploaded the file again and left it unprotected.
Thanks again
Hi, Treecko,
like mentioned in my last post: if I add a Workbook_Open-event in ThisWorkbook like
I canīt find any problem using Win8.1 and Excel2013.
Please Login or Register to view this content.
Ciao,
Holger
Thanks for the very quick reply. Sorry as my VB experience is very much an amateur. I still have the issue that it works when I have the file open,but if I close/save the file, then open it again it relies on me enter the password again at the start to have the column L work properly. Once I enter the password and enter something in the cell in column L, it then reverts back to a protected sheet. I upload the VB formula. I a also using Excel 10 version (sorry for not mention it earlier)
Thanks again
Please Login or Register to view this content.
Hi, Treecko,
did you insert the posted code Workbook_Open into ThisWorkbook and save the file, close it, reopen it and test?
Ciao,
Holger
Hi again HaHoBe
I'm sorry, I can't seem to get the formula to work, I've tried what you said but think the biggest problem is the glitch between the keyboard and the processor (me) lol.
Regards Treecko
Hi, Treecko,
instead of copying the code behind each sheet itīs in ThisWorkbook now and working foir all sheets except List:
Ciao,Please Login or Register to view this content.
Holger
Hi HaHoBe
I tried opening and closing your attached file a least a dozen times making additions and playing with it. It worked Great!!!.
I thank you very much for taking time to help me with my issue. This is one file, for my things I was taught folder.
Again much appreciated
Treecko
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks