Search results for query: *

I need to disable the ability to paste(Ctrl+V) into a textbox on a form in Excel(VBA). Basically I have operators scanning barcodes into a textbox and I want to force them to scan the barcode and not copy/paste the data into the textbox. any ideas? Thanks in advance, PcFred

Currently I'm populating a combobox in excel from a access database. I need to sort the data in the combobox to display in alpha order and the access database is in order of automatic record ID. Can this be done w/o putting the data on a worksheet and then sorting?

Is there an easy way to display a continuous form horizontally vs. vertically?

When in the "open file" dialog box in any office app, clicking on the browse button results in an indefinite hanging of the app. Any ideas? thanks

I have a multi column combobox with 3 columns on a form. When I select the dropdown box I can see all 3 columns but when I select an entry the result in the combobox only shows the first column. How can I get it to display all 3 columns? thx pcfred

I'm trying to create a label on a Excel Userform that is an email hyperlink but I can't seem to figure it out. Any Ideas? thanks PcFred

I've got a simple question that I can't seem to find the answer to. How can I get data into the second column of the msflexgrid instead of it defaulting to the first column? this is what I've got so far. Private Sub UserForm_Initialize() Dim cRow As Integer cRow = 2 Do Until ActiveCell =...

Just curious. I don't want to password protect the file. Is there anyway of preventing someone from disabling the Auto_open macros while opening an excel workbook.

I have some code that creates a desktop shortcut. Problem is if the shortcut already exists on my desktop I don't want the button to be visible. How can I return a boolean value to determine this?

I have some code that creates a desktop shortcut. Problem is if the shortcut already exists on my desktop I don't want the button to be visible. How can I return a boolean value to determine this?

I have an Excel 97 workbook with hyperlinks in it. When I click on one of the hyperlinks my workbook becomes hidden within that instance of excel. Anyone know why?

I have an Excel 97 workbook with hyperlinks in it. When I click on one of them and Internet Explorer fires up, my workbook becomes hidden. Anyone know why? [neutral] pcfred

I have a spreadsheet with a lot of VB in it and I need to limit any user from saving it as a new version of Excel(2000 or higher). Does anyone know how to limit this to just the Excel 97 version through code or another means? Thnx in advance, PCFred

How can I keep certain files from showing up in the recent file list?

Anybody know where I can find a list to reference which icons goto which faceid numbers for a popup menu? thx, PcFred

I'm running a VBA program through excel 97 and I was wondering if you can somehow add a minimize button to a userform.