Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with VB Objects in Excel
Hi All,
I was wondering what could be wrong here. I created a workbook that had a couple of labels and buttons on a worksheet, though when I opened the file on another computer they were missing of the screen, they were there though because I opened it on another computer they were there. Thanks in advance Jason |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with VB Objects in Excel
Are you sure macros are enabled in the pc where it is not loading...
Security level should be low/medium in (Tools|Macro|Security) If this post helps click Yes --------------- Jacob Skaria "Jason Zischke" wrote: Hi All, I was wondering what could be wrong here. I created a workbook that had a couple of labels and buttons on a worksheet, though when I opened the file on another computer they were missing of the screen, they were there though because I opened it on another computer they were there. Thanks in advance Jason |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with VB Objects in Excel
Hi Jacob
Thanks for the responce, macros were enabled. The only thing wrong is that it can't seem to show the button or label on the worksheet. I think a file for the VB functions has been changed to do this, I just need to know which file and how I can fix it. Jason "Jacob Skaria" wrote: Are you sure macros are enabled in the pc where it is not loading... Security level should be low/medium in (Tools|Macro|Security) If this post helps click Yes --------------- Jacob Skaria "Jason Zischke" wrote: Hi All, I was wondering what could be wrong here. I created a workbook that had a couple of labels and buttons on a worksheet, though when I opened the file on another computer they were missing of the screen, they were there though because I opened it on another computer they were there. Thanks in advance Jason |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with VB Objects in Excel
Are you saying if you scroll the sheets (horizontally and vertically), that the controls do not come in to view? Just out of curiosity, where did the controls come from... the Forms toolbar, the Control Toolbox toolbar and/or the Drawing toolbar?
-- Rick (MVP - Excel) "Jason Zischke" wrote in message ... Hi Jacob Thanks for the responce, macros were enabled. The only thing wrong is that it can't seem to show the button or label on the worksheet. I think a file for the VB functions has been changed to do this, I just need to know which file and how I can fix it. Jason "Jacob Skaria" wrote: Are you sure macros are enabled in the pc where it is not loading... Security level should be low/medium in (Tools|Macro|Security) If this post helps click Yes --------------- Jacob Skaria "Jason Zischke" wrote: Hi All, I was wondering what could be wrong here. I created a workbook that had a couple of labels and buttons on a worksheet, though when I opened the file on another computer they were missing of the screen, they were there though because I opened it on another computer they were there. Thanks in advance Jason |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with VB Objects in Excel
Hi Rick
Thanks for the responce. To answer your questions the labels and buttons do not show on the sheet where they were placed, and they are from the control toolbox toolbar. Jason "Rick Rothstein" wrote: Are you saying if you scroll the sheets (horizontally and vertically), that the controls do not come in to view? Just out of curiosity, where did the controls come from... the Forms toolbar, the Control Toolbox toolbar and/or the Drawing toolbar? -- Rick (MVP - Excel) "Jason Zischke" wrote in message ... Hi Jacob Thanks for the responce, macros were enabled. The only thing wrong is that it can't seem to show the button or label on the worksheet. I think a file for the VB functions has been changed to do this, I just need to know which file and how I can fix it. Jason "Jacob Skaria" wrote: Are you sure macros are enabled in the pc where it is not loading... Security level should be low/medium in (Tools|Macro|Security) If this post helps click Yes --------------- Jacob Skaria "Jason Zischke" wrote: Hi All, I was wondering what could be wrong here. I created a workbook that had a couple of labels and buttons on a worksheet, though when I opened the file on another computer they were missing of the screen, they were there though because I opened it on another computer they were there. Thanks in advance Jason |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with VB Objects in Excel
How far off the sheet are they. What I am trying to find out is basically if they were originally placed near the right or bottom edges of the worksheet and were (on that other computer) just a few rows down from, or a few columns to the right of, these edges... if so, the problem may have to do with the Windows Display Settings, namely, the Font Size (DPI) setting. If your DPI setting is at, say 96 DPI and that other computer is set to, say, 120 DPI, then less columns and less rows would be displayed meaning the cells the buttons and/or labels are "attached" to could now be off the screen (out of view).
-- Rick (MVP - Excel) "Jason Zischke" wrote in message ... Hi Rick Thanks for the responce. To answer your questions the labels and buttons do not show on the sheet where they were placed, and they are from the control toolbox toolbar. Jason "Rick Rothstein" wrote: Are you saying if you scroll the sheets (horizontally and vertically), that the controls do not come in to view? Just out of curiosity, where did the controls come from... the Forms toolbar, the Control Toolbox toolbar and/or the Drawing toolbar? -- Rick (MVP - Excel) "Jason Zischke" wrote in message ... Hi Jacob Thanks for the responce, macros were enabled. The only thing wrong is that it can't seem to show the button or label on the worksheet. I think a file for the VB functions has been changed to do this, I just need to know which file and how I can fix it. Jason "Jacob Skaria" wrote: Are you sure macros are enabled in the pc where it is not loading... Security level should be low/medium in (Tools|Macro|Security) If this post helps click Yes --------------- Jacob Skaria "Jason Zischke" wrote: Hi All, I was wondering what could be wrong here. I created a workbook that had a couple of labels and buttons on a worksheet, though when I opened the file on another computer they were missing of the screen, they were there though because I opened it on another computer they were there. Thanks in advance Jason |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
insert objects problem | Excel Discussion (Misc queries) | |||
Problem trying to use Excel objects in VS 2005 Express - Worksheet | Excel Programming | |||
Excel VBA Class Objects - Parent & Successor Objects | Excel Programming | |||
Problem opening Excel file 1 time with embedded Word objects | Excel Programming | |||
Unable to remove Sheet objects in the Microsoft Excel Objects | Excel Programming |