| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compacting Excel-VBA file
Hi,
I have heard that Excel keeps an "invisible" sheet with variable & procedure names that are used in VBA, but that this sheet will not be "compacted" if you delete such a procedure. If so, is there any way to make this sheet "visible" and compact it manually? Cheers, Oliver |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Compacting Excel-VBA file
Oliver,
I think you heard incorrectly. Excel doesn't keep a worksheet with variable and procedure names used in VBA. You can clean extraneous internal VBA "garbage" by using Rob Bovey's CodeCleaner add-in, available for free at www.appspro.com . -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Oliver Kharraz" wrote in message ... Hi, I have heard that Excel keeps an "invisible" sheet with variable & procedure names that are used in VBA, but that this sheet will not be "compacted" if you delete such a procedure. If so, is there any way to make this sheet "visible" and compact it manually? Cheers, Oliver |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to copy 2007 excel file formula results into a 2003 Excel file | Excel Discussion (Misc queries) | |||
| compacting spreadsheets | Excel Discussion (Misc queries) | |||
| Compacting a file | Excel Discussion (Misc queries) | |||
| opening an excel file opens a duplicate file of the same file | Excel Discussion (Misc queries) | |||
| compacting UPPER/LOWER & column reference | Excel Worksheet Functions | |||
Linear Mode
