excel length
New Member
- Joined
- Jan 29, 2013
- Messages
- 19
Hi,
good day.
i am working on an excel file with lots of marcos,basically it was made from a simple macro until it became more complicated as i work on it.
What I wanted is to hide some codes (not necessarily all codes), I dont want others to mess up with my codes since I myself cant exactly remember everythings i've done.
i dont want to use password on codes since they will be more curious on it so i wanted to hide those complicated codes.
what i am thinking of is, using a macro, place the entire code in a cell, then copy and create a module from it then delete the entire module after running.
is it possible? can anyone provide me a code?
Thanks in advance.
good day.
i am working on an excel file with lots of marcos,basically it was made from a simple macro until it became more complicated as i work on it.
What I wanted is to hide some codes (not necessarily all codes), I dont want others to mess up with my codes since I myself cant exactly remember everythings i've done.
i dont want to use password on codes since they will be more curious on it so i wanted to hide those complicated codes.
what i am thinking of is, using a macro, place the entire code in a cell, then copy and create a module from it then delete the entire module after running.
is it possible? can anyone provide me a code?
Thanks in advance.