Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Controls in all worksheets are suddenly invisible
This problem is affecting all of my Excel worksheets that have controls
placed in them (e.g. Command Buttons). The controls have all disappeared! Looking at their properties, it appears that the controls have all become 960 wide by 0.75 high, i.e. just a thin line. I can resize them to a normal size, but there is no graphic displayed, only a blank rectangle with a red X in the top left corner. The control still functions properly, e.g. it's possible to click on a Command Button and get the Click procedure to run. If I try to place a new control on the worksheet, it has the same problems. The problem does not occur with forms (as opposed to worksheets). The controls on forms all appear normally. If I move these workbooks to another computer, everything appears as it should be. So it must be a problem with my installation or configuration. Excel has worked OK on this computer for years, this has just started happening. Short of uninstalling and reinstalling Excel, is there a simple fix to this problem? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Controls in all worksheets are suddenly invisible
Just a wild guess...
Save your file with the controls resized. Close excel clean up the windows temp folder Windows start button|Run type: %temp% to get to that folder quickly Delete as much as you can Restart excel and see if it helped. Sabba wrote: This problem is affecting all of my Excel worksheets that have controls placed in them (e.g. Command Buttons). The controls have all disappeared! Looking at their properties, it appears that the controls have all become 960 wide by 0.75 high, i.e. just a thin line. I can resize them to a normal size, but there is no graphic displayed, only a blank rectangle with a red X in the top left corner. The control still functions properly, e.g. it's possible to click on a Command Button and get the Click procedure to run. If I try to place a new control on the worksheet, it has the same problems. The problem does not occur with forms (as opposed to worksheets). The controls on forms all appear normally. If I move these workbooks to another computer, everything appears as it should be. So it must be a problem with my installation or configuration. Excel has worked OK on this computer for years, this has just started happening. Short of uninstalling and reinstalling Excel, is there a simple fix to this problem? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Command to count number of worksheets in a workbook? | Excel Worksheet Functions | |||
Copy Worksheets from one Workbook to Another | Excel Worksheet Functions | |||
Adding same cells across multiple worksheets | Excel Worksheet Functions | |||
Changing a Link Mid-way Across Worksheets | Excel Worksheet Functions | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) |