Hello,
I want to protect in my excel programm everything except a few single cells. Therefore there shall be only a few input fields.
Currently my VBA program wants to write in other cells too. But I want to protect those of the user.
I couldn't make it work, because these cells seem to be protected for my VBA-application as well!
It would be great, if anybody could help me out of this and tell me how to configure that only Excel itself is allowed to write and no one else?
Thanks a lot!
Lausa
Hi, Lausa,
If you open the workbook or activate the sheet and then protect the sheet/sheets by passing the parameter UserIenterfaceOnly:=True macro action will be allowed while normal action still is forbidden. Please note that this action will not be saved with the workbook but hast to be repeated on each opening of the workbook.I couldn't make it work, because these cells seem to be protected for my VBA-application as well!
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks