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

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

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

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

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

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