Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
macro security trusted sources | Excel Programming | |||
Excel Macro Security Problem - Trusted macros not running for users (but do run for domain admins) | Excel Programming | |||
How to get the security warning, add myself as trusted publisher | Excel Discussion (Misc queries) | |||
Trusted Security Tab | Excel Programming | |||
Trusted Security Tab | Excel Programming |