Re: Read-only quandary

You can lock the code project: in the VB Editor, in the Project Explorer window, right-click on the project name, then click on the popup menu item "[Project] Properties..."

A "[Project] - Project Properties" dialog will appear; click on the Protection tab.
Click a checkmark next to "Lock project for viewing" and then enter and confirm a password.

The next time you re-open the template, you won't be able to view the code modules, without entering the password.
This will similarly affect users, including if/when they were to (forfend!) get a run-time error message and clicked on the Debug button.

Re: Read-only quandary

Yes.
The locked project only affects access to the VBA code modules.

BTW, what are the circumstances (if you don't mind elucidating) in which you don't mind the users mucking about with the templates? (or am I just reflecting the prejudices of my 'in-house developer' mindset?<g>)

Re: Read-only quandary

>> BTW, what are the circumstances (if you don't mind elucidating) in which you don't mind the users mucking about with the templates? (or am I just reflecting the prejudices of my 'in-house developer' mindset?<g>) <<

Yeah, you are. <returning g>

The template I'm creating is for writing comic book scripts, and I'll be making it available from my website to any writer who wants it.

For distribution purposes, I have to use the most common fonts -- Arial and Courier New, for example -- in the paragraph styles. But writers, being every bit as quirky and cantankerous as programmers, all have their individual preferences when it comes to things like the appearance of a script. (Heck, I don't even like Arial and Courier New. Arial is 'way overused, and Courier New prints like an old, worn typewriter ribbon, far too light.) I just want them to be able to indulge those preferences without wrecking the code.

If I were developing the template for in-house use at a particular comics publisher, this wouldn't be a concern. Among other things, I could use whatever fonts I liked, secure in the knowledge that every employee would have that font on his or her computer.

Re: Read-only quandary

>> Thanks for clarifying. Sounds like you are doing the best thing considering the situation. I'm curious about the template. Think I'll download and take a look. Thanks. <<

I'll post a note here when it's done and maybe make a unlocked version available to the forum users, so they can take the code (and me) apart for what I'm sure are multiple and heinous VBA transgressions.

Re: Read-only quandary

Writing comics (and other stuff) is my real job. I originally put the template together just for my own use, back in the Word 6.0 era. Then I made the mistake of mentioning it somewhere online, and other writers began asking if they could try it out. That left me with two choices: either say "no," which seemed impolite, or actually figure out what I was doing.

Woody, Eileen Wharmby, and a number of others from the WOPR forum's earlier incarnation on CompuServe were instrumental in helping me do the latter. You and Chris have been every bit as helpful this time around. I really can't tell you how grateful I am.