On Apr 17, 12:41 pm, steviewood wrote:
> Hello,
>
> I have managed to code some of this but would really appreciate some
> help with the final part.
>
> I have a worksheet doubling up as a questionnaire, structured as
> shown...
>
> 0
Hello,
I have managed to code some of this but would really appreciate some
help with the final part.
I have a worksheet doubling up as a questionnaire, structured as
shown...
0 1 2 Result
option1option2 option3
Q1option1
options.
Say we score row 1 as option 2, row 2 as option 1 and row 3 as option
3 then row 2 and a score of zero will be in the Results column.
Your help with this is greatly appreciated
On Apr 16, 11:07 am, steviewood wrote:
> Ok scrub this I have got it working now for all cells, except for
e
Else
Range("D" & clearcell & ":" & "H" &
clearcell).Interior.ColorIndex = xlNone
.Interior.ColorIndex = 45
End If
End With
Cancel = True
End If
endit:
Application.EnableEvents = True
ActiveSheet.Protect Pass
Hi,
I have a worksheet which operates as a questionnaire with scoring
cloumns. I have managed to write a macro that will change the colour
of the cell upon double clicking however I'd also like to do a few
more things that with my VB knowledge I'm unable to code.
What I'd like to happen is,
- s
t; Because you cannot change the height of individual cells, you must
> change the height of the entire row, including the locked cells.
>
> again, I think it would be much easier if we could see the code...
>
> Paul
>
>
> From: steviewood
&
Hello,
I have a macro to reformat the height of a group of merged cells which
makes up the "comments section". All the others cells on the worksheet
are locked apart from this one and the sheet protected. However when
the macro runs to re-format the box height, the cell becomes locked
disabling t
