Disable checkbox use but keep fomratting of an enabled checkbox.

[99moorem]

Hi Mr Exceler's

I have had a little look around for something like this, and I may just be being silly.

But is there a way to disable the users ability to check/uncheck a check box with out gerying out the box?

I have a form (not building within a form, built within the cells and sheets) and it will be published and printed but in between published and printed it gets checked. I have locked all the cells and protected them so that these can not be changed but I can not work out how to do smilar for check box's without making them grey out.

I am using ActiveX checkbox's so I have the events etc if that helps.

Idealy without the need for VBA as this is for a published version. If it needs to have it then its not a major thing.

Any help would be appreciated

Thanks

Marc

 

[99moorem]

Hi Guys,

Anyone got a rough solution for this or some where for me to start looking?

Thanks

Marc