Copy and paste function for Command Button
Hi all
I am after some much needed help!
I am creating a form which will allow a number of different users the ability to open the document and then update the form with their weeks worth of work. At the end of the week the form can be collated and analysed by supervisors.
The form consists of a simple table which i with to restrict to ensure there is no editing of the table.
I want to add a 'Add new entry' command button which will allow a user to simply click and it will copy the above table and insert it below. Allowing all previous entries to remain and simply add a new table below ready for the member of staff to complete.
They will simply save the document and someone else can open it when they have completed some more new work.
I believe i can do this with a Macro however i can't get the macro to work or be able to assign it ot the button
Any help will be appreciated
Thanks all
|