Restrict OpenEvent code to one column

Can I amend the following code such that ONLY when a cell in column B is selected,
formatting that cell is permitted ?

Please Login or Register  to view this content.

I particularly wish to allow changes to:
font colour, fill colour, italic, bold and underline.

Thanks.

Hi there,

Try inserting the following code into the VBA CodeModule of the worksheet you wish to edit, and see if it does what you want:

Please Login or Register  to view this content.

The highlighted value corresponds to Column B - this can be altered to suit your requirements.


Hope this helps - please let me know how you get on.

Regards,

Greg M

Hi Greg, thanks.

I had thought of something like that, but worried about handing control back to the sheet with protection removed.

I guess now they'll be able to do stuff as long as they don't select another cell ?

Is there a way (after your code runs) to limit their freedom with the selected cell
to just:
font colour, fill colour, italic, bold and underline ?

Many thanks.

Hi again,

Take a look at the attached workbook - it allows only formatting of the font characteristics of cells in Column B.

The following code is inserted in a standard VBA CodeModule:

Please Login or Register  to view this content.

It's might be possible to allow the cell background colour to be changed also, but that would definitely make life more complicated.

Hope this helps - as before, please let me know how you get on.

Regards,

Greg M

Greg,

Many thanks for the help, and the workbook - at my level, never even knew about application.dialogs !

I think I'll keep the workbook on one side for future reference, and work with the code example you gave me.
See where that leads.

Many thanks again.

Regards.

Hi again,

Many thanks for your feedback - glad I was able to help (even if not 100% )

Best regards,

Greg M