Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi.
I'm working with an Excel file that was the output of Oracle's older version of ADI (Application Desktop Integrator)... the version of ADI that was a deskop app itself, and may be running some old Excel things. There's a code module called "CODE" in it, which shows as a module in the VBE. But, when asked how many sheets the file has, Msgbox ActiveWorkbook.Sheets.Count , the module with the CODE is being included as a sheet. I've proved this by removing the module CODE, and it then reports 29 sheets. Originally, I had thought they probably had a sheet with property visible = xlVeryHidden , but that was not the case. Is there a property somehwere where I can tell when a module of code is being included in the sheet count? Thanks, Mark |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to count without included duplicate records | Excel Worksheet Functions | |||
How do I keep blank pages from being included in header count? | Excel Worksheet Functions | |||
count number of items in a row? help *file included* | Excel Worksheet Functions | |||
Find and Replace code in Sheet modules | Excel Programming | |||
When to code in sheet or userform modules and when to use modules | Excel Programming |