Replace Protection Warning Pop Up Using VBA

[Celtic_Avenger]

Hi.....Tis Me Again..........

I have created a macro to protect a sheet after a pivot table has bee
updated into it. However I have still allowed users to sellect th
locked cells.

When the user then tries to enter data you get the usuall "The Cell o
Chart you are trying to change is protected and therefore read
only............." pop up warning. It then advises the user t
unprotect the sheet using the "tools menu, protectio
submenu...........". In my spreadsheet the main toolbars have bee
removed and my own menu replaces them, so there is no "Tools Menu, o
Protection Submenu".

Is there a way I can have my own pop up window displayed using th
msgbox code that will give a message of my choosing?

I hope this can be done!

Any Ideas?

Thanks in advance!

Celtic_Avenger
:confused

 

[Tom Ogilvy]

This has been asked many times - I have never seen anyone suggest that this
can be done.

 

[Celtic_Avenger]

Thanks.......I thought that this may be the case........I will just g
back to the option of not allowing any cell selection, this will the
stop the pop-up alltogether.


Thanks again!

Celtic_Avenger
: