Pop-Up Text Box
 

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

Pop-Up Text Box
 

To expand on this slightly, I can create a pop-up that appears on every page
by putting an Auto_Open Msgbox in the ThisWorkbook module, but can't figure
out how to get it to work on only one worksheet.

TIA

"Risky Dave" wrote:

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