Programming

Uer Form Window resizing according to Monitor
I have a User Form that for some reason it does not want to resize according to the Display settings on the computer. What I mean is that the User Form Fits on the Screen, but the User Form Window seems to be larger than the Screen is. I need for the Entire User Form & Window to resize according to the Monitor... 2 Feb 2010 17:30

stop numbers auto rounding
I am using Excel 2007. Does anyone know how to stop automatic rounding of numbers if i want to keep my sheet cells numbers format "general" so that the exact number will be displayed i hop if worksheet change code or function code ? Thanks. ... 2 Feb 2010 17:30

How do I find the currently selected Scenario?
Hi, Maybe this is a simple thing, but I don't seem to be able to track it down. I have an Excel sheet with a couple of Scenarios defined. I am trying to implement some VBA functions where I need to know which Scenario is currently selected. Does anyone know how I determine the active Scenario from VBA? Any he... 22 Feb 2010 07:26

Locked cells
I would like to select all locked cells on a worksheet. How can I find all of the locked cells without having to loop through every individual cell on the worksheet? I know range.locked will return true if all cells in the range are locked but it will return false if one or more of the cells are unlocked. This ... 2 Feb 2010 17:30

Hide Message Bar
I have a series of macros that modify data in a protected workbook. Only certain users have permission under SharePoint to run the macros and modify the data. At the end of the macro it displays a worksheet (read only) with the current edited data visible for all to see. But I also get a Message Bar (Excel 200... 2 Feb 2010 17:30

No print settings in Excel HTML files
Is there a way to prevent users from printing the HTML files that are created from an Excel workbook ? I see there is html code to do this, but I don't know how to put that into the Excel workbook so that it is always there when the files are updated (which they are frequently). ... 2 Feb 2010 17:30

sql to database
Hi, On MS Excell using VBA, I would like to send a sql command to and MS Access database "delete * from mytable where id=89" Thank you all!!!! ... 2 Feb 2010 17:30

how to get address of source of copy (range with marquee a.k.a. "marching ants")
In the Worksheet_SelectionChange event, is there a way to determine the range of cells currently highlighted with the marquee, given that CutCopyMode is true? The reason I'd like to know is that I am changing the Enable state of a command button depending on the Target range (i.e. where the user is placing the c... 2 Feb 2010 17:30

Constants
I use the following constant in a number of macros without any issues: Const ConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\Corp\Public\Groups\Accounting\Trans.mdb; Persist Security Info=False" I have sent a new macro to a user at one of our cost centers and they are getting the ... 2 Feb 2010 17:30

Excel prompts for VBA password when opening
Hola, I have a workbook in which I protected the VBA code with a password. It works fine. The user doesn't have access to the code. I'm automatically setting the Solver referece using the following code (partly shown). Set oWB = ActiveWorkbook strSolverPath = Application.LibraryPath & "\SOLVER\SOLVER.XLAM... 2 Feb 2010 17:30