[SOLVED] hide/disable button based on cell value

I have a sheet with 4 buttons, start, stop, reset and view leaderboard, these are command buttons 1 to 4.

The below code is supposed to make the command button 2 only visible if the entry in cells L14 and L17 is P. (Windings2 shows a 'tick' for an uppercase P).

However when I press on the 'Start@ button I get an error.

Run-time error'1004':
Method 'Range' of objet '_Worksheet' failed

The code is.

Please Login or Register  to view this content.

The codes for the buttons are as follows

Please Login or Register  to view this content.

Any help appreciated.

Try this:

Please Login or Register  to view this content.

ps Forum Rules require you to place code tags around your code so it displays correctly across different platforms. Just click Edit Post, select your code text, and click the # icon on the Editing toolbar. Thanks!

Did that work? If yes, please go to Thread Tools (up top) and mark your thread as SOLVED. Thanks! - Lee

So by messing about I've noticed that if I'm entering text into a text box the timer continues to run.
is it possible to have a situation where a formula in cell L14 looks for words in a text box that match a list of keywords in cells S1:S4, and returns a letter "P" if the words are there, or a "O" if not?


Alternatively is there a way of changing the command button 1 code, or adding/changing any code to ensure that the timer does not stop when I edit cells in the worksheet?