I have a worksheet for customers to confirm they are satisfied with the service they receive.
My logo is at the top of the sheet ( inserted as a picture ) and there is a box at the bottom ( Customer Signature ) which the customer signs with the mouse ( using the Drawing tool )
My problem is, when I protect the worksheet to stop anyone changing the format, the picture image can still be moved around ,deleted, amended etc but the drawing tool works OK. ( Enabled Objects checked )
If I uncheck the Enable Objects box ( in protect sheet ) the image cannot be amended but the Draw Tools are greyed out and cannot be used for signing.
I have also tried – Text Signature – but again when the box - Enable Objects - is unticked the Draw Tools are un available.
In image format - Properties I have made sure Locked is ticked but this does not help.
Can anyone tell me if there is any way to permanently stop the image being moved. deleted or amended while still being able to use the drawing tool in signature box.
Is there any VBA I could use and if so could you give me an example of what I need to input as I am a novice as far as VBA is concerned.
Sheet copied below but there should be an image in top right hand corner (see image) which I cannot copy.
My logo is at the top of the sheet ( inserted as a picture ) and there is a box at the bottom ( Customer Signature ) which the customer signs with the mouse ( using the Drawing tool )
My problem is, when I protect the worksheet to stop anyone changing the format, the picture image can still be moved around ,deleted, amended etc but the drawing tool works OK. ( Enabled Objects checked )
If I uncheck the Enable Objects box ( in protect sheet ) the image cannot be amended but the Draw Tools are greyed out and cannot be used for signing.
I have also tried – Text Signature – but again when the box - Enable Objects - is unticked the Draw Tools are un available.
In image format - Properties I have made sure Locked is ticked but this does not help.
Can anyone tell me if there is any way to permanently stop the image being moved. deleted or amended while still being able to use the drawing tool in signature box.
Is there any VBA I could use and if so could you give me an example of what I need to input as I am a novice as far as VBA is concerned.
Sheet copied below but there should be an image in top right hand corner (see image) which I cannot copy.
| Mr Excel.xlsx | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | |||
| 1 | Protrietor | |||||||||
| 2 | 1 Church Street | |||||||||
| 3 | Anytown | |||||||||
| 4 | Anywhere | |||||||||
| 5 | PP3 TT5 | |||||||||
| 6 | Mobile:- | |||||||||
| 7 | e-mail:- | |||||||||
| 8 | ||||||||||
| 9 | Date | |||||||||
| 10 | ||||||||||
| 11 | SATISFACTION NOTE | |||||||||
| 12 | ||||||||||
| 13 | ||||||||||
| 14 | Ins. Ref. No. | |||||||||
| 15 | Vehicle | |||||||||
| 16 | Vehicle Reg No. | |||||||||
| 17 | Chasic No. | |||||||||
| 18 | ||||||||||
| 19 | Name | |||||||||
| 20 | ||||||||||
| 21 | ||||||||||
| 22 | ||||||||||
| 23 | Address | |||||||||
| 24 | ||||||||||
| 25 | ||||||||||
| 26 | ||||||||||
| 27 | This to certify that the repairs to my vehicle have been carried out | |||||||||
| 28 | to my satisfaction | |||||||||
| 29 | ||||||||||
| 30 | ||||||||||
| 31 | ||||||||||
| 32 | Customer Signature | |||||||||
| 33 | ||||||||||
| 34 | ||||||||||
| 35 | ||||||||||
Enable Objects Unticked | ||||||||||
