How about having your macro unprotect the sheet, do the work and then reprotect
the sheet?

SYBS wrote:

Hi, hope somebody can throw some light on this problem I am having with macros.

I have a scoresheet with 60 contestants. Each contestant takes up 7 rows,
the first six of which are hidden to start with and I have put macros in the
adjoining column so that when they are clicked, the full 7 rows open up and
the table of scores can be entered, When entry is complete for that
contestant, a further macro when clicked will close up the 6 rows, leaving
just the main line (line 14) with the No, Name, €œOPEN€� macro and other Totals
in adjoining columns.

The sheet works fine, but as many people will use this programme, I need to
protect the sheets against mistaken entries etc., and as soon as I protect
it, the macros wont work and throw up a €œunable to set the property of a
hidden range class, run time error 1004. I dont want to leave the sheet
unprotected, can anyone advise me where I am going wrong.

I am also trying to find a way to validate €œtime taken€� entries so that they
can only be input as minutes and seconds in the format of 09.56, within a
range of 00.01 €“ 10.00. Not having any success with this as it keeps
converting the data into something like a date.

I would be very grateful for any help you can give me.

Thanks in anticipation.

Sybs

--

Dave Peterson