J
Jock
I posted a q yesterday about this but was unclear in what I was after.
What I would like is for the cells from A7 down to turn grey when the user
toggles to 'read only' using the "Toggle read only" button on a tool bar.
When the user toggles back to read/write, those same cells go back to
unformatted.
The first part can be done using Workbook_open but I need something to work
when the file status changes when the workbook is already opened.
Thanks,
What I would like is for the cells from A7 down to turn grey when the user
toggles to 'read only' using the "Toggle read only" button on a tool bar.
When the user toggles back to read/write, those same cells go back to
unformatted.
The first part can be done using Workbook_open but I need something to work
when the file status changes when the workbook is already opened.
Thanks,