Thread: Registry
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Patrick Molloy[_4_] Patrick Molloy[_4_] is offline
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