View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alastair MacFarlane Alastair MacFarlane is offline
external usenet poster
 
Posts: 5
Default 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