#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 103
Default Registry

why not use

IF Application.Version=8 then
Worksheets(1).Activate
else
Worksheets(2) activate
end if


--
Patrick Molloy
Microsoft Excel MVP
----------------------------------
"Phil Perry" wrote in message
...
Can someone advise on the code to check the registry
flag browser (value=8) in
MyComputer\HKey_Current_User\Software\Microsoft\Of fice\8.0
\Excel

i want the code to detect the value and then if it is 8
to select Sheet 1 and if it isn't 8 to select Sheet 2

thank you



Reply
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
Managing add-ins via the registry Athos Setting up and Configuration of Excel 0 February 5th 09 01:00 PM
How Can I Unblock Registry Settings to allow .wk1 Files gbarofavn Excel Worksheet Functions 1 January 8th 09 02:16 PM
Another checkbook registry problem... LJB Jazz Excel Worksheet Functions 5 August 13th 06 02:53 PM
error accessing system registry Donna Excel Discussion (Misc queries) 2 July 11th 06 09:22 PM
XP windows Registry Question saziz Excel Discussion (Misc queries) 1 June 11th 06 02:25 AM


All times are GMT +1. The time now is 12:04 AM.

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

About Us

"It's about Microsoft Excel"