LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,514
Default excel 97 -Trusted source security tab now missing

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
Search this Thread:

Advanced Search
Display Modes

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
macro security trusted sources Erol Excel Programming 0 May 12th 09 04:22 PM
Excel Macro Security Problem - Trusted macros not running for users (but do run for domain admins) Alan Excel Programming 0 January 22nd 07 10:12 PM
How to get the security warning, add myself as trusted publisher Judy Excel Discussion (Misc queries) 1 December 19th 05 05:52 PM
Trusted Security Tab VJ Excel Programming 1 October 7th 04 06:47 PM
Trusted Security Tab Ron de Bruin Excel Programming 0 October 7th 04 05:57 PM


All times are GMT +1. The time now is 04:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"