PDA

View Full Version : Solved: Run-time error '1004': Issue



coliervile
04-02-2007, 05:38 AM
In the following workbook I've unprotected specific cells so that when a password protects the worksheet a user can only tab to the unprotected cellsto input data. The problem I've come across is that the unprotected cells that are checkmarks, when tabbed to, causes the following error; "Run-time error '1004'"
Unable to set the Name property of the Font class

Any suggestions? :help :dunno The password for worksheet is "password".

Best regards,

Charlie

Bob Phillips
04-02-2007, 06:14 AM
Unprotect and protect in the code

coliervile
04-02-2007, 06:23 AM
xld thanks for your help. Obviously it make a difference when protecting and unprotecting a work sheet through?

Best regards,

Charlie