Hello,
I've been using XL 97 for years.
I am using VBA and to set the Trusted Source", we always do:
"On the Tools menu, point to Macro and then click Security .
In the Security dialog box, click the Trusted Sources tab.
Click to select the Trust access to Visual Basic Project
check box. "
We installed XL 2007 last week so we have 2 versions of XL on each
pc.
We start up the version of XL before starting our program so we can
control which version of XL is used.
We are still testing ,things appear to be working as expected EXCEPT
the SECURITY menu item of the MACRO is not showing.
Is this a known conflict if you are running 2 versions of XL on the
same pc?
Please, what can we do to get the SECURITY menu item back and have 2
versions of XL on the same pc?
thanks
softie
I have XL97 to XL2007 installed on my XP machine, and XL2003 to XL2010
on this Win7 Pro machine and my Win8.1 machine. All are working as they
should!
Try doing a 'Repair' of XL97 in ControlPanel's Add/Remove Programs
dialog. Note, though, that doing this may reset XL97 as your default
(depending on OS).
Like you, I pre-select a version before opening files. (I use a
stand-alone quick-launch toolbar similar to the old Office Shortcut Bar
name "Freebar", which is written entirely in VB6)
If you don't mind me asking.., why do you need XL97 installed?
--
Garry
Free usenet access at
http://www.eternal-september.org
Classic
VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.
vb.general.discussion