Sir Babydum GBE
10-24-2005, 05:06 AM
Hi
I have some sheets that I?m not allowed to put any macros in, so I need to run code from a master.
My Master workbook will be called "Master Workbook" (I was feeling particularly creative when I thought of that)...
The master contains 3 sheets:
"Copy Formats"
"Copy Formulas"
"Validation"
There are several slave workbooks that are sent out for others to update ? but we are sometimes needing to change the formulae and conditional formatting of the sheets as our needs evolve.
So, can someone help me with the following please?:
The master workbook will look for any workbooks open whose filenames? begin with the word "slave"
In each "slave" book the macro will unprotect the workbook using "myPassword" and unhide the sheets called "Main" and "Validation"
On all sheets except "validation" (different books will have different sheet names) the formatting from Master?s "Copy Formats" sheet will be applied to the entire worksheet areas (A1: IV65536) but only the formats
Again, on all sheets except "validation" the formatting from Master?s "Copy Formulas" sheet (columns O through Z) will be applied columns O through Z
The info on the Master?s "Validation" sheet will be copied to the Slave?s "Validation" sheet. (all cells again)
Finally, sheets "Main" and "Validation will be hidden, and the workbook will be protected with "myPassword"
Had i been allowed to use macros in the Slave sheets this would have been easy for me ? but I?m not good at looping through un-named workbooks, so I need help.
Thanks in advance :)
I have some sheets that I?m not allowed to put any macros in, so I need to run code from a master.
My Master workbook will be called "Master Workbook" (I was feeling particularly creative when I thought of that)...
The master contains 3 sheets:
"Copy Formats"
"Copy Formulas"
"Validation"
There are several slave workbooks that are sent out for others to update ? but we are sometimes needing to change the formulae and conditional formatting of the sheets as our needs evolve.
So, can someone help me with the following please?:
The master workbook will look for any workbooks open whose filenames? begin with the word "slave"
In each "slave" book the macro will unprotect the workbook using "myPassword" and unhide the sheets called "Main" and "Validation"
On all sheets except "validation" (different books will have different sheet names) the formatting from Master?s "Copy Formats" sheet will be applied to the entire worksheet areas (A1: IV65536) but only the formats
Again, on all sheets except "validation" the formatting from Master?s "Copy Formulas" sheet (columns O through Z) will be applied columns O through Z
The info on the Master?s "Validation" sheet will be copied to the Slave?s "Validation" sheet. (all cells again)
Finally, sheets "Main" and "Validation will be hidden, and the workbook will be protected with "myPassword"
Had i been allowed to use macros in the Slave sheets this would have been easy for me ? but I?m not good at looping through un-named workbooks, so I need help.
Thanks in advance :)