Un editable cell in macros work sheet

[donkey_uk]

HI All

I have a risk assessment template that has lots of macros to make it work, this is all working how it should, however, i need to be able to edit cell A24 on the "Cover sheet" tab, i can type in the cell but unable to change the font, could or even text size, as every time i click on the cell all the boxes above are grayed out, would some be able to let me know what i need to do to correct this please

Thank you

[romperstomper]

That cell has a Forms textbox over the top of it, so you aren't actually selecting the cell (unless you are using arrow keys to it)

[donkey_uk]

That cell has a Forms textbox over the top of it, so you aren't actually selecting the cell (unless you are using arrow keys to it)

Ok, how can i change that so i can edit it ? thank you

[romperstomper]

Go into design mode (using the blue triangle button on the Developer tab) then right-click the textbox and choose Properties. You can then alter things like the font and back colour

[donkey_uk]

Go into design mode (using the blue triangle button on the Developer tab) then right-click the textbox and choose Properties. You can then alter things like the font and back colour

Hey perfect that worked, thank you so much for your help, this was driving me mad lol

[romperstomper]

Glad we could help.