Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Aligning Wraped Text to the bottom of a cell | Excel Discussion (Misc queries) | |||
Conversion to Text file format error | Excel Discussion (Misc queries) | |||
Shade cell according to text? | Excel Discussion (Misc queries) | |||
Using Concatenate function to generate text in Text Box | Charts and Charting in Excel | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |