Macro Help

P

pchi55555

I am pretty new to VBA, could someone please tell me how to protect th
source code so that the User will not be able to edit or modify th
Macro code. I want to disable the Edit and and Delete buttons. Anothe
problem that I am having - when I copy and Paste Special Values fro
one sheet to another some of the text columns that have long 20 digi
numbers get copied as Numbers (exponential Form) with a '+' sign nex
to it. How can I prevent this from occuring. Any help is greatl
appreciated.

Thank
 
F

Frank Kabel

Hi
for your first question:
in the VBA editor right-click on the project name, choose 'properties'
and add a password

20 digit numbers: As Excel only supports 15 significant digits your
numbers have to be stored in scientific format. No chance to change
this if you need to calculate with them
 
Top