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

--
Regards,
Tom Ogilvy

"Celtic_Avenger " wrote in
message ...
Hi.....Tis Me Again..........

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

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

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

I hope this can be done!

Any Ideas?

Thanks in advance!

Celtic_Avenger



---
Message posted from http://www.ExcelForum.com/