Macro Help

  • Thread starter Thread starter pchi55555
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel macro help needed to copy columns from one open excel toanother open excel, and shall run on a 5
vba powerpoint pasting named shape in selected named slides 0
Linking to Objects in Worksheet 4
Need help on VBA excel macro and API to close an external application 0
Linking data from .CSV to Excel - HELP! 1
Excel macro code for copying data to a cell reference which is set byvalues in two separate cells in 3
Macro Runtime errors 8
MACRO RUN random percentage and copy of column values 1

Back
Top