LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default Can I detect if user has Excel 2007 and display different pages?

Hi Steven

Better two answers for the OP then no answer

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


wrote in message ...
Looks like you beat me to it Ron.


Steven

On Sep 15, 11:54 am, "Ron de Bruin" wrote:
You can test it with

If Val(Application.Version) < 12 Then
'97-2003
Else
'2007
End If

I use it for example on this pagehttp://www.rondebruin.nl/mail/folder1/mail2.htm

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm

wrote in ...
I spent years developing a software applicaitonthat has extra menu
items at the top, and it works, finally, really well...on Excel 2003.
Along comes 2007, and the add-ins now are hidden from the soccer moms
that use the program in an obscure 'add-on' box. Is there any way that
I can detect that someone using my program has Excel 2007 and display
special help messages or something so that I do not have to rewrite
everything? I have seen ways to change the ribbon back to the 2003
headers, but if the user is familiar with the ribbon concept, that
could even cause more confusion in the future. Thanks in advance
(again).


 
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
Excel 2007 doesn't detect OneCare as an antivirus program David Walker Setting up and Configuration of Excel 1 January 3rd 08 07:52 PM
How do I display two excel pages at the same time? snowtime New Users to Excel 1 August 6th 05 02:21 AM
VBA Script to detect user input Fraggs[_19_] Excel Programming 2 August 2nd 04 04:33 PM
How to detect user quitting excel danzel Excel Programming 2 June 8th 04 12:18 PM
how to detect if user has a dialogbox open Von Shean Excel Programming 2 January 12th 04 02:35 PM


All times are GMT +1. The time now is 06:57 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"