CheckBox open File

[Lenny_821]

Hi Bob,

Thanks for that code, but in the sheet I don't want use any checkboxe
. I am trying to make it as user friendly as possible for other user.

Lenny

 

[Bob Phillips]

Lenny,

This doesn;t use checknboxes, but it allows your user to select/deselect a
cell. You can put a caption in an adjacent cell and change it as you wanted.
You can then check if a cell is selected (=IF(A1="a", ...) and take action.

--

HTH

RP
(remove nothere from the email address if mailing direct)