Programmatically modifying code using VBE in a protected project

Posted to microsoft.public.excel.programming

Alex van der Spek[_2_] Alex van der Spek[_2_] is offline

external usenet poster

Posts: 2

Programmatically modifying code using VBE in a protected project

I am programmatically changing code lines to allow users to modify a
modelfunction in Excel:

So I use the VBE like:

ThisWorkbook.VBProject.VBComponents("Maincode").Co deModule.ReplaceLine 6,
CodeLine

Does anyone know how to do this and still lock the project for viewing
using a password?

Thanks!
Alex van der Spek

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Programmatically unprotect my protected project to delete modules?	Toby Erkson	Excel Programming	3	December 13th 06 05:52 PM
Code Sign PW Protected Project?	Walt Weber[_2_]	Excel Programming	1	February 26th 05 01:27 AM
Programmatically delete macro using a protected project	John Cole, Jr.	Excel Programming	1	November 14th 04 04:22 PM
Assigning the Help 4, *.HLP file for a project programmatically in a protected Project	Tony Seiscons	Excel Programming	0	October 4th 04 03:10 PM
replace line of code in vba protected project	Konrad[_5_]	Excel Programming	0	November 26th 03 08:27 PM

All times are GMT +1. The time now is 01:36 PM.

Menu

About Us