Recent content by tbtcust

Hello combo. This is resolved. I'm now resetting the Height, Width, Left, and Top properties after the "Zoom can be undefined" code you posted above. The link did not help, but you did get me thinking along the lines of just resetting all the control properties. Thanks

Hello combo, No, there is no code behind any buttons that changes zoom, position or size of controls.

Thank you combo. This code puts me much closer. Is there away to keep the controls from changing size and position? When the code run (on a lower resolution PC) the range I want is visible and the controls look fine. When I click a control (button) it gets very large and so does the font.

Hello All, how can I re-size a worksheet and it's ActiveX buttons based on a user's PC resolution? Is there a way to reliably detect the screen resolution and adjust the worksheet with the ActiveX controls? I have developed a worksheet with ActiveX controls in resolution 1600 x 900. When a...

Hello All, I had a Hommer moment over the weekend. It occur to me that instead of recreating the email wheel, to get images, rich text, attachments, etc. sent in the feedback process I should simply use what's there. So I have VBA some code that calls/opens the email software, populates the...

Thank you SkipVought for replying. I understand what you are saying. Maybe I need a control the holds text and graphics. I have created a feedback function, via a form and email. I want the users to have the ability to past a snapshot into the email's text box an click send. I don't want...

Hello all, I have a text box on a ActiveX form. I have an image on my clipboard. The image can be bitmap, jgp, gif, etc. Is it possible to past that image into the text box? What would I need to code for this to work? Thanks in advance for any help.

Hello combo. This does work. I see what I was doing wrong. This is resolved. Thank you.

Thank you combo. This works. Issue resolved.

Hello combo, Thank you for the post. This only gets me part way there. The user can still scroll right. Any other suggestions would be greatly appreciated.

Hello all, I have an ActiveX toggle button on a worksheet How can I pull the Value ("True" or "False") from the Toggle in a module using Excel VBA? Thanks in advance for any help.

Hello All, I have a worksheet that has hyperlinks in some of the cells. I am using a macro to prevent scrolling on this worksheet. When I prevent the scrolling, via Developer tab ===> Properties ===> ScrollArea A1:Y1 the hyperlink are not clickable. Is there a way to prevent a sheet from...

Thank you both. your suggestions worked just fine. This is resolved.

Hello All, How can I dynamically create EXECL tabs from a list of names in a master tab from a macro? I have a master tab with personal data. In that tab there is a column that has a list of names that repeat - I need to get a distinct list of names from that column - I need to take that list...

Hello all, I have a single source file that I want to split into multiple target files. The source file will vary and contain the target path and file names. See below for details. I want to create generic process that will not rely on hardcoded target path and file names. Is this possible...