I have an excel file with some pop-up forms.
If the sheet is password protected I can't run the forms but i need some cells to be blocked so the regular user can't edit the total etc.
Can be done?
I have an excel file with some pop-up forms.
If the sheet is password protected I can't run the forms but i need some cells to be blocked so the regular user can't edit the total etc.
Can be done?
Please consider:
Be polite. Thank those who have helped you.
Click the star icon in the lower left part of the contributor's post and add Reputation. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Posting code between tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
Since the text next to the cells is in Romanian, I can understand it a little but, What are you trying to do?
You can leave cells unlocked that will allow double click and have the rest locjed (sheet protected0
Add the parameter UserInterfaceOnly:=True with the protect code and the macros will always be able to modify all cells, locked or not only the user is blocked.
But again.
The calendar form doesn't work on my system so what is it you're trying to do?
Can you explain one action that you want to do and see if I can help.
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
You're code is very inconsequent and messy.
Without an explanation of what you're trying to do, I'm sorry, won't work
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks