I have a large spreadsheet with multiple worksheets in it.
When one specific worksheet is selected (it does the calculations used on
the other pages) I would like a pop-up text box to appear warning the user
not to print it.
Is there a relatively easy way to do this given that I can't write
VB
(though I can just about follow it in the
VB editor)?
Another option would be to completely hide the tab, but when I do this, the
macros that refer to the page from other worksheets fail to function
correctly. Is there a way around this?
Any help/suggestions/sample code gratefully received.
TIA