View Single Post
 
Old 05-12-2021, 05:43 AM
Will267 Will267 is offline Windows 10 Office 2019
Novice
 
Join Date: May 2021
Posts: 1
Will267 is on a distinguished road
Default 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
Reply With Quote