[RESOLVED, for the time being] Excel File Size

[si_the_geek]

You wouldn't necessarily need to run anything in Workbook_Open, if all of your users have macros enabled then there would be no need (as the required changes would have been done by Worksheet_Change).

A good way to force people to only use it when macros are enabled is to have a dummy sheet, which simply contains text saying that they need to re-open it with macros enabled. This sheet would be hidden by Workbook_Open (and all other sheets shown), and it would be re-shown by Workbook_Save/Close (and the others hidden).

[Siddharth Rout]

Okay here is an example...

let's say i have master file which has the Employee ID's of 500 people, their 1st names and their last names.

now I want to create a Quality tracker which should have the following details

1) 5 different sheets. 4 for 4 weeks data and 1 for summary
2) each weeks data will have the following column heading
a) employee ID, Employee 1st name, 2nd name, Reports to, total score, and sixteen other columns for sub scores.

Now these 16 columns are the most irritating ones cause they all have validations set. so in all I am talking about

1) (500people * 16 cells of validations)* 4 sheets
2) A grand summary using subtotals to pick up data from all the 4 weeks
3) different colors to 'beautify' the sheet (as per management's requirements)
4) 4 different types of charts based on the summary excluding a chart which does a comparison of last month's data... phew!!!!

Hope u understand...