Objects Disappear and Reappear

S

samsilverman

Board Regular
Joined
Nov 9, 2009
Messages
176
Windows 10, Excel 2016

We have some workbooks with command buttons and text boxes on the opening worksheet. When the workbook is opened, sometimes the buttons and/or text box fail to appear. If you were to tab to another worksheet and then back again, they appear. This is not a critical problem, but a nagging one. Can someone help with this please?
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
Sort by date Sort by votes
samsilverman said:
Windows 10, Excel 2016

We have some workbooks with command buttons and text boxes on the opening worksheet. When the workbook is opened, sometimes the buttons and/or text box fail to appear. If you were to tab to another worksheet and then back again, they appear. This is not a critical problem, but a nagging one. Can someone help with this please?
Click to expand...

I have the same problem, only this is critical for me. Has anyone got a solution?
 
Upvote 0
You must log in or register to reply here.

Similar threads

W
  • Question
Command buttons changing to pictures?
Replies
3
Views
392
skillilea
S
R
  • Solved
Worksheet CodeName as type Worksheet
Replies
7
Views
185
StephenCrump
S
B
  • Question
Show a form created with an addin in active window with 2 or more different sheets
Replies
4
Views
332
BennyBatt
B
GMC The Macro Man
  • Solved
VBA Script - Return to named file
Replies
6
Views
197
mumps
mumps
R
  • Question
The cursor is not positioned in the middle of the text box after setfocus
Replies
1
Views
503
Micron
M

Forum statistics

Threads
1,215,425
Messages
6,124,827
Members
449,190
Latest member
rscraig11

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top