Posted 08 March 2008 - 04:04 AM
Sorry, RandomUser, this is not what you WANT, but it may provide what you NEED. When I want a set of user directions or a framework on all sheets in a Workbook, I set up a template like this:
Open a new workbook.
On Sheet 1, type the common information you want into cells A2 to, let's say, B5.
Go to Sheet 2.
In cell A2, type "=", click cell A2 back on Sheet 1, then hit ENTER.
Drag that cell formula (on Sheet 2) down to A5, then across to B5 (two actions, I'm afraid).
For safety's sake, I always protect that construction, like this:
Select your whole expected work area on Sheet 2, and choose Format-Cells-Protection
Clear the "Protected" tick from the check box.
Then select the template area you want to share, and choose Format-Cells-Protection again
This time check the "protected" box.
Now choose Tools-Protection-Protect Sheet. What do you want to protect? Do you need a password?
Sheet 2 is now a template that you can copy and re-use in that (or any other) workbook, as often as you want.
That's not sophisticated, but it's functional.