Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Hari
 
Posts: n/a
Default Difference in the listing of the New module addition in 2002 version

Hi,

I have Excel 2002 at home and also at work.

At home when I add a new module (using Insert module) Then it gets listed
under "VBAProject (Book1)" and it is in the same tree node as "Sheet1
(Sheet1)", "Sheet2 (Sheet2)" , "Sheet3 (Sheet3)" "This Workbook". There is
no separate "Microsoft Excel objects" folder.

While at Work when I insert a new Module it gets added under a folder called
Module which is basically part of the tree node "VBAProject (Book1)". Also
at work I have a separate "Microsoft Excel objects" folder under which
"Sheet1 (Sheet1)", "Sheet2 (Sheet2)" , "Sheet3 (Sheet3)" "This Workbook".

Please tell me what causes this difference?

Thanks a lot,
Hari
India


  #2   Report Post  
Chip Pearson
 
Posts: n/a
Default

In the Project Explorer window, where the tree view is, click on
the folder icon at the top to toggle between the two display
modes.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Hari" wrote in message
...
Hi,

I have Excel 2002 at home and also at work.

At home when I add a new module (using Insert module) Then it
gets listed
under "VBAProject (Book1)" and it is in the same tree node as
"Sheet1
(Sheet1)", "Sheet2 (Sheet2)" , "Sheet3 (Sheet3)" "This
Workbook". There is
no separate "Microsoft Excel objects" folder.

While at Work when I insert a new Module it gets added under a
folder called
Module which is basically part of the tree node "VBAProject
(Book1)". Also
at work I have a separate "Microsoft Excel objects" folder
under which
"Sheet1 (Sheet1)", "Sheet2 (Sheet2)" , "Sheet3 (Sheet3)" "This
Workbook".

Please tell me what causes this difference?

Thanks a lot,
Hari
India




  #3   Report Post  
Hari
 
Posts: n/a
Default

Hi Chip,

Got it.

Thanks a lot,
Hari
India


"Chip Pearson" wrote in message
...
In the Project Explorer window, where the tree view is, click on
the folder icon at the top to toggle between the two display
modes.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Hari" wrote in message
...
Hi,

I have Excel 2002 at home and also at work.

At home when I add a new module (using Insert module) Then it
gets listed
under "VBAProject (Book1)" and it is in the same tree node as
"Sheet1
(Sheet1)", "Sheet2 (Sheet2)" , "Sheet3 (Sheet3)" "This
Workbook". There is
no separate "Microsoft Excel objects" folder.

While at Work when I insert a new Module it gets added under a
folder called
Module which is basically part of the tree node "VBAProject
(Book1)". Also
at work I have a separate "Microsoft Excel objects" folder
under which
"Sheet1 (Sheet1)", "Sheet2 (Sheet2)" , "Sheet3 (Sheet3)" "This
Workbook".

Please tell me what causes this difference?

Thanks a lot,
Hari
India






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



All times are GMT +1. The time now is 09:07 PM.

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

About Us

"It's about Microsoft Excel"