Hi,
I have a shared workbook with a protected sheet that contains buttons to run scripts. The only reason the sheet is protected is to stop users messing with the buttons format or assigning another macro, etc.
What I would like to do is change the colour of the cell adjacent to each button once that macro has been run, to notify the user what stage in the process they are.
I know I can unlock certain cells in a protected sheet, but I still come up against the brick wall of the shared workbook.
If this cannot be done within a shared workbook maybe there is a workaround? Does anyone know of a way to make a button uneditable without protecting the sheet that it sits on?
Any help or advice will be greatly appreciated.
Thanks,
Roy
PS. I'm using Excel 2000
I have a shared workbook with a protected sheet that contains buttons to run scripts. The only reason the sheet is protected is to stop users messing with the buttons format or assigning another macro, etc.
What I would like to do is change the colour of the cell adjacent to each button once that macro has been run, to notify the user what stage in the process they are.
I know I can unlock certain cells in a protected sheet, but I still come up against the brick wall of the shared workbook.
If this cannot be done within a shared workbook maybe there is a workaround? Does anyone know of a way to make a button uneditable without protecting the sheet that it sits on?
Any help or advice will be greatly appreciated.
Thanks,
Roy
PS. I'm using Excel 2000