| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
DTPicker on Sheet Error
Hi all, I have placed a DTPicker on one of my sheets at it works fine - except when i first open my application. The DTPicker displays a red cross and then loads onto the sheet wrong - it look distorted and the wrong shape. Anyone know any ideas to solve this? I have tried placing another DTPicker on the sheet and it does the same thing. When I go onto another sheet then reload my menu sheet the DTPicker is showing perfectly. TIA -- gti_jobert ------------------------------------------------------------------------ gti_jobert's Profile: http://www.excelforum.com/member.php...o&userid=30634 View this thread: http://www.excelforum.com/showthread...hreadid=534052 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
DTPicker on Sheet Error
ok.....how do I use a calendar control on a spreadsheet without it messing up? TAIA -- gti_jobert ------------------------------------------------------------------------ gti_jobert's Profile: http://www.excelforum.com/member.php...o&userid=30634 View this thread: http://www.excelforum.com/showthread...hreadid=534052 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
DTPicker on Sheet Error
Have the same problem, solved it by placing this in the ThisWorkbook module:
Private Sub Workbook_Open() ActiveWindow.Zoom = 75 ActiveWindow.Zoom = 100 End Sub "gti_jobert" skrev i melding ... Hi all, I have placed a DTPicker on one of my sheets at it works fine - except when i first open my application. The DTPicker displays a red cross and then loads onto the sheet wrong - it look distorted and the wrong shape. Anyone know any ideas to solve this? I have tried placing another DTPicker on the sheet and it does the same thing. When I go onto another sheet then reload my menu sheet the DTPicker is showing perfectly. TIA -- gti_jobert ------------------------------------------------------------------------ gti_jobert's Profile: http://www.excelforum.com/member.php...o&userid=30634 View this thread: http://www.excelforum.com/showthread...hreadid=534052 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
DTPicker on Sheet Error
Thank you so much, solved the issue!! -- gti_jobert ------------------------------------------------------------------------ gti_jobert's Profile: http://www.excelforum.com/member.php...o&userid=30634 View this thread: http://www.excelforum.com/showthread...hreadid=534052 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to look up value in another Sheet based on criteria in first sheet. | Excel Worksheet Functions | |||
| Error message with protected sheet | Excel Discussion (Misc queries) | |||
| Excel Error Message: "Cannot shift objects off sheet" | Excel Discussion (Misc queries) | |||
| linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
| Naming & renaming a sheet tab | Excel Worksheet Functions | |||
Linear Mode
