ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Cleaning file (https://www.excelbanter.com/excel-programming/413503-cleaning-file.html)

djExcel

Cleaning file
 
Hi all,

I have a file (created with macros) which have a cover sheet containing
group of macrobuttons. User can add various number of sheets (containing
tables, charts, etc.) to this file. So basically there is cover sheet and
normally less than 10 other sheets in the file.

Now I need to create a 'clean' file without cover and macros. Problem is,
that there might be some charts, which use data from another sheet (=are
linked to another sheet). If I just copy those sheets to another file and
remove links, charts aren't working properly any more. Any suggestions?


All times are GMT +1. The time now is 10:53 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com