ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Registry (https://www.excelbanter.com/excel-programming/271672-re-registry.html)

Patrick Molloy[_4_]

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





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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com