Hi
the cells with the numbers are cells that de user must be fill in.
In the calendar i use symbols to set the day of work.
How can i make that user can't see my vba code and thy can see my password in vba
kalender.jpg
Hi
the cells with the numbers are cells that de user must be fill in.
In the calendar i use symbols to set the day of work.
How can i make that user can't see my vba code and thy can see my password in vba
kalender.jpg
Hi, in the VBAPRoject's properties you can set the view and password protect the so that it's not visible or accessible except to those that have the password.
---
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
and for the cells that are indicated with a value on the picture.
The user must only fill in these celles
en on the sheet ether is also my signature and it my not delete
leave only the cells where you want the user to input data unlocked, lock all the other cells
as you can see i use a symbol that i put on the day the user take a holidy and the symbol is set by vba
So i have to unlock the hol calendar
not if you code correctly. When you protect the worksheet using VBA add the parameter UserInterFaceOnly:=True
I suggest you read on that, google this parameter so you can understand the functionality, will be easier than me explaining it all, but with an image I cannot help anyway I would need a file WITH the vba
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks