Disabling VBA Functions in Office 97 Installatiion

[Greg]

I would like to disable Visual Basic for Applications functionality within
Microsoft Office 97 so that the users I have will not be able to write
programs.

 

[Chip Pearson]

I forget if VBA was an optional component in 97. You'd have to do
a complete re-install on each computer, installing Office without
VBA. As I said, I don't know if this was an option in 97. In any
case, it is not a trivial task.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Jonathan West]

I would like to disable Visual Basic for Applications functionality within
Microsoft Office 97 so that the users I have will not be able to write
programs.

This is impossible. VBA is not an optional component of Office 97.

--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org

 

[TC]

Just for fun, I tested to see if the VBAOff registry value would work
with office 97 or 2000. It didn't. Then I scanned various office 97
EXEs and DLLs for the string "vbaoff". It existed!

Nice try - but: vbaoff8.hlp etc.

TC

 

[Steve Rindsberg]

I would like to disable Visual Basic for Applications functionality within
Microsoft Office 97 so that the users I have will not be able to write
programs.

I'm not certain of the other apps, but PowerPoint at least depends on VBA for a
number of functions you might think are internal.

If you *could* disable VBA (and of that I'm not sure), you'd lose any functions
the apps rely on VBA for.

 

[TC]

Sure. For example, you can't install Access, or use any VBA
functionality of an existing Access installation.

Various kb articles refer to the restrictions; eg.
http://support.microsoft.com/kb/281953

Cheers,
TC