ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Opening Excel 2002 VBA Editor (https://www.excelbanter.com/excel-programming/271180-opening-excel-2002-vba-editor.html)

jacob[_2_]

Opening Excel 2002 VBA Editor
 
When opening an Excel 2002 VBA editor I do not see any
data in the project explorer window or properties. Thus,
I can not insert a module to work on. In Excel 2000, when
the VBA editor was launched, by default in the project
pane you would see sheet1, sheet2, sheet3. In Excel 2002
that does not appear. Is that supposed to be tha way? If
it is how do you insert a module? If not, what do you
think is wrong?

Thank you in advance for your help......

Ron de Bruin

Opening Excel 2002 VBA Editor
 
Press CTRL-R Jacob when you are in the Editor

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"jacob" wrote in message ...
When opening an Excel 2002 VBA editor I do not see any
data in the project explorer window or properties. Thus,
I can not insert a module to work on. In Excel 2000, when
the VBA editor was launched, by default in the project
pane you would see sheet1, sheet2, sheet3. In Excel 2002
that does not appear. Is that supposed to be tha way? If
it is how do you insert a module? If not, what do you
think is wrong?

Thank you in advance for your help......





All times are GMT +1. The time now is 05:27 PM.

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