Yes that worked thank you. Do you know how to get rid of the shadow around
the box? I don't want the box to show when I print it?

"Rowan" wrote:

Not sure about saving invoices to another folder but in design mode, right
click the textbox, select properties and enter the releveant cell address (eg
F2) in the LinkedCell field.

Hope this helps
Rowan

"Marlis" wrote:

I created a text box through the control toolbox. I want to lock it to a
cell, so that I can create a macro which saves the invoices in another folder.