Hi Guys,
New here, but it seems like this is the place I need to be. Hopefully someone can help, I ihave been researching this for what seems like an age with no success.
I have a spreadsheet which is to be filled in by multiple users, in order to assist the users I have colour coded, and left unprotected, the cells that they need to interact with. I really don't want them messing with the formulae!
However, when a user chooses to print the sheet I would like the coloured cells to be printed in B&W.
I have a very little VBA knowledge - I know I need something to follow 'Private Sub Workbook_BeforePrint ()' or at least, I think I do!!
Any ideas??
Thanks in advance,
Nigel
New here, but it seems like this is the place I need to be. Hopefully someone can help, I ihave been researching this for what seems like an age with no success.
I have a spreadsheet which is to be filled in by multiple users, in order to assist the users I have colour coded, and left unprotected, the cells that they need to interact with. I really don't want them messing with the formulae!
However, when a user chooses to print the sheet I would like the coloured cells to be printed in B&W.
I have a very little VBA knowledge - I know I need something to follow 'Private Sub Workbook_BeforePrint ()' or at least, I think I do!!
Any ideas??
Thanks in advance,
Nigel