JCHuysamer
New Member
- Joined
- Nov 3, 2015
- Messages
- 43
Hi
Can anyone please assist
I am compiling a new template that will be given to our service providers to complete and list their job activities, safety mitigation and so on and so forth.
I am 99% done (with a lot of help from some of the guys on this forum) but have one last hurdle I cant crack
.
The service providers have done a lot of these documents and used to just copy relevant info from their previous forms and past into the new one.
The problem I have is that when they copy (from their previous documents) and paste in a cell it overwrites my default cell format and border.(unless they paste it in the formula bar)
Is there any way one can lock the entire document so that when they enter text it will be in Arial 10 (I have set the default and this part works fine) and if they paste (CTRL+V or right click, Paste) info into a cell it will only paste the info and not the properties of the original cell (ie.: change the properties of the new info to Arial 10 and not adjusting the borders).
Can anyone please assist
I am compiling a new template that will be given to our service providers to complete and list their job activities, safety mitigation and so on and so forth.
I am 99% done (with a lot of help from some of the guys on this forum) but have one last hurdle I cant crack
The service providers have done a lot of these documents and used to just copy relevant info from their previous forms and past into the new one.
The problem I have is that when they copy (from their previous documents) and paste in a cell it overwrites my default cell format and border.(unless they paste it in the formula bar)
Is there any way one can lock the entire document so that when they enter text it will be in Arial 10 (I have set the default and this part works fine) and if they paste (CTRL+V or right click, Paste) info into a cell it will only paste the info and not the properties of the original cell (ie.: change the properties of the new info to Arial 10 and not adjusting the borders).