Dear Excel Gurus,

I often work with large multiple spreadsheets in a given workbook. The
spreadsheets have identical structure within each book. They differ from
each other only in respect of the data content of each sheet.

My productivity would be increased immeasurably if I could issue a 'global
command' to apply to a given workbook which does three things which will
enable each worksheet to open with an identical view and with identical cell
selection position:
--set all worksheets view to the same magnification
--set all worksheets view to the same cell range
--position the cursor or a selected cell in the same position in each
worksheet.

The 'global' command would need to be resettable in any given session of my
working on the same workbook, so that I could for example, work on one area
of the sheets in one magnification and then change the setting so as to work
on another area of each worksheet at another magnification and etc.

I would be very grateful if someone could suggest a command I could use.

Regards,

Peter