lock text box to cell
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. |
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. |
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. |
In the properties window select the Categorized tab. Near the top you will
find all the properties which alter the Appearance of the textbox. I would probably start by changing the SpecialEffect to Flat. Regards Rowan "Marlis" wrote: 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. |
lock text box to cell
Hi Rowan,
I was browsing through the discussion list and thought of requesting for some assistance. the number of characters (letters, numbers, signs - they are all mixed) in a merged cell containers about may be 1000 or more. this merged cell is linked to a general text box in another sheet. However all contents of the merged cell does not appear in the linked text box. I have tried resizing the text box but all text does not appear. As if a half or quarter of the text is cut. What could be the problem? Thanks in advance for your help. -- Rizvi "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. |
All times are GMT +1. The time now is 03:41 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com