Dear Hemant,
You can protect your VB project with a good password and that would be the best
solution to your predicament! No one can then view your code, leave alone
modify them.
Sorry that I am unable to comment on the registry thing.
Anil Kumar Agarwala
Anil Agarwala & Co.
Chartered Accountants
3rd Floor, Adiba Mansion
Maszid Lane, Kamarpatty
Fancy Bazar
Guwahati : 781001
Assam
+91 361 2638864 (Telefax)
+91 361 2517820 (Office)
+91 361 2606184 (Residence)
+91 9435086605 (Mobile)
akagarw...@gmail.com
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On
Behalf Of Daniel
Sent: Monday, July 13, 2009 1:20 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Seeking help from Excel Macro experts : (Force to
enable Macros, Disable design mode, make the project unviewable)
Hello.
1. You can protect the sheets with a password before closing the workbook and
removing the protection at opening, if macros are enabled.
2. Don't know. You cannot prevent action from another workbook macro.
3. If you want to prevent any change in your workbook, why don't you define a
password enabling only read only opens ?
Regards.
Daniel
> -Message d'origine-
> De : excel-macros@googlegroups.com [mailto:excel-
> mac...@googlegroups.com] De la part de Hemant
> Envoyé : dimanche 12 juillet 2009 17:50
> À : MS EXCEL AND VBA MACROS
> Objet : [Norton AntiSpam] $$Excel-Macros$$ Seeking help from Excel
> Macro experts : (Force to enable Macros, Disable design mode, make the
> project unviewable)
>
>
> Hi friends
>
> I have learnt about excel macros by trial and error method and now I
> have a moderate knowledge to write macros with which I am able to
> write small usable excel applications.
>
> Lately I have written a macro which can extract financial data from an
> accounting software (Tally) and prepare some of the financial
> statements (in a format required by law with related computations and
> disclosures). But because of my limited knowledge about VB, I am not
> able to add some features to that workbook which I really want to
> add!!
>
> Any help relating to the following will be highly appreciated:
>
> 1)Force user to enable Macros:
>
> I have already done this to some extent by using this trick:
>
> a)While closing the workbook, I hide all the sheets except one
> which
> contains instructions for the user about how to enable the macros.
>
> b)When the user opens the workbook with macros disabled, he will
> see
> that page, otherwise the normal sheets will become visible
> programmatically and the sheet containing the instructions will be
> hidden.
>
> Problem I am having here is how I can prevent the user from entering
> the DESIGN MODE before he saves and closes the workbook?? You can
> guess what will happen if he does that!
>
>
> 2)How to make the VBA project unviewable (not just locking for
> viewing, I want to disable the VB editor itself if possible)
>
>
> 3)My workbook will necessarily make some entries to the system
> registry as I plan to disable saving any changes to that workbook. I
> want to know when there can be a risk of loosing the data on the
> registry.
> Loosing that data may be fatal to some of the functions of my
> workbook. Would it be a better option to save the data in a text file
> rather than on the registry?
>
>
>
> Thanks in advance friends :)
>
> >
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 5,000 subscribers worldwide and receive many nice notes about the
learning and support from the group. Our goal is to have 10,000 subscribers by
the end of 2009. Let friends and co-workers know they can subscribe to group at
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---
