Forum Discussion
Prevent Text Box from being copied to a new sheet .
Is it possible to add a text box to a sheet that cannot be copied when that sheet is copied to a new tab? In other words - I have a workbook with several tabs. Tab 7 is intended to be a change orde...
Tried to replicate what you described but failed. Perhaps because I added a text box as a rectangle shape since the form control textbox icon in the Developer ribbon is greyed out on my Excel (don't know why). File attached.
I can copy the Sheet1 the way you describe (right-click, Move or Copy... etc., or add a sheet then select the entire Sheet1, copy and paste to the new sheet, or press right Alt key and drag sheet to the right and drop it.
Neither of these options copies the shape with the instructions but data and formulas do. Give it try and let me know.