Well, I open a brand new excel sheet and hit alt-F11 and it open the VB
editor. I see File Edit View etc. And the rest is blank. Now if I got
"View" - then "Code" It opens a white box on the left there is a dro
down menu with 2 selections "General" and "Worksheet". No where on th
VBA editor do I see ThisWorkBook. I even searched for ThisWorkBook i
help and all it said was ThisWorkBook properties but did not show ho
to get there.

Srry, I can't find it

--
Message posted from http://www.ExcelForum.com

Hi
in the left window should be a eplorer tree view with your workbook
file as one project. Expand this project and the first entry below
should be 'ThisWorkbook'

another option:
- open your workbook
- right-click on the Excel symbol directly left to the menu 'File'
- choose 'Code'
- now you're in the workbook module

--
Regards
Frank Kabel
Frankfurt, Germany
"CWit " schrieb im Newsbeitrag
...
Well, I open a brand new excel sheet and hit alt-F11 and it open the
VBA
editor. I see File Edit View etc. And the rest is blank. Now if I
goto
"View" - then "Code" It opens a white box on the left there is a drop
down menu with 2 selections "General" and "Worksheet". No where on
the
VBA editor do I see ThisWorkBook. I even searched for ThisWorkBook in
help and all it said was ThisWorkBook properties but did not show how
to get there.

Srry, I can't find it.


---
Message posted from http://www.ExcelForum.com/

OMG THANK YOU FRANK!!! Huge Smile on my FACE :) :)

I right clicked the symbol and viewed code and it work!! Thanks Fran
and everyone else for making this Simple but Frustrating Headache g
away..

--
Message posted from http://www.ExcelForum.com

:-)
finally

--
Regards
Frank Kabel
Frankfurt, Germany
"CWit " schrieb im Newsbeitrag
...
OMG THANK YOU FRANK!!! Huge Smile on my FACE :) :)

I right clicked the symbol and viewed code and it work!! Thanks Frank
and everyone else for making this Simple but Frustrating Headache go
away...


---
Message posted from http://www.ExcelForum.com/