Procedure Run Order
Dear All,
I have two procedures which should run one after another:
(a)Call CreateDlyBankSht - Sets up the workbook
(b)Call LockWorkBook - Locks the Workbook and certain
customisations.
I get an error stating that I cannot ammend cells because
the cells are locked. It looks as though the second
procedure is being run before the first one is complete.
Is there a way of telling Excel to undertake the first
procedure and complete it before the second procedure is
run?
Thanks again...
Alastair MacFarlane
|