| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Capture a worksheet in VBA
Hi all,
I have a huge worksheet full of sumproduct formulas which fatches links from various other files and creats summary reports.I do not want to reveal formulas I have used which will be used against me (directly or indirectly). Manually creating VBA code for the same for more then 300 formulas is quite tedius. Is there a way by which I can capture the status of the whole sheet (all formulas and links) in VBA which can be used later to creat the sheet again when required? Regards, Madiya |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| unsure how to set up worksheet to capture data | Excel Discussion (Misc queries) | |||
| Excel screen capture to capture cells and row and column headings | Excel Discussion (Misc queries) | |||
| Macro to capture worksheet names | Excel Worksheet Functions | |||
| Can you capture worksheet double click event from an Add-In???? | Excel Programming | |||
| Capture mouses X &Y position on a worksheet | Excel Programming | |||
Threaded Mode
