Search:

I would like to extract and count distinct values from a range and sort by the Pareto. If I were using a DB this would be easy.

Select column2, column3, count(column3) from table where some...

Thanks Fred. We use several of ELO's touch screens. Some people have cleaned them with desk cleaner. It works quite well. It cleans well into the membrane holding the 5 wire resistance "stuff." ...

When one watches the news or weather, they use touch screens. Items are resized using two hands. Items are pushed off screen by flinging them. What technology does this? Is it built into Windows...

I am aware that if I change the order in which the workbooks are open, all works fine. However, I cannot ensure the end users follow that same pattern. I have ~90 workbooks in this model. It looks...

I don't want two ranges to have the same name. Someone forgot to tell the accounting folks about this bad practice, therefore that is the way it is. We have a huge model, with speadsheet rolling up...

I have 2 workbooks as follows

Book1 contains two named ranges. MyRange1 has a scope of sheet1 and MyRange1 has a scope of Workbook. Note: two distinct ranges, two different scopes, both have the...

Found it. It is the same as before, but getting there is different.

Now one goes to "Tools, Options" - "Advanced" tab and there is a button at the lower left for file locations. I can keep my...

I would like to add my own custom Visio Templates (myfile.vst). I would like them in a folder named "MyCompany", so that when I click "File, New" there is a folder "MyCompany" with my 3 custom...

Sorry 'bout that.

From HKCU to HKLM.

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\11.0\Excel\Security]
"Level"=dword:00000002

Thanks Tim, but that sets the macro security for one user.

I found it though. I looked in the registry under HKCU to see what changed when I set the macro security, and the applied it to HKLM. ...

How do I change the default macro security level for all users to Medium from high?

Thanks

I believe you got it right, Rory. Further (but I am not sure yet), It only seems to be those with Excel 5 macros saved in compatibility mode.

Thanks to both of you for the help.

I have worksheets created with Excel, perhaps as far back as Excel 4. They were last saved in Excel 2003, I believe in 2003 file format. When I try to save them using 2007 I get "[file name].xls...

I am looking for Rockwell (Allen Bradley) shape, or general Programable Logic Controller (PLC) shapes for Visio. does anyone have a source. Thanks.

Firefox download dialog box looses the file name. In other words, when I click on download, the area where the download file name should have been passed in from the browser, is empty. I can click...

break the zip code down into two cells. The Text to Column feature will do this, but will not preserve the orignial.
The mid formula will work well for you if the zips are consistent.
...

I figured it out. It is easy. Initially I tried setting SaveAsUI to false, to cancel the save as. I need to trap it instead.

Thanks.

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As...

I want to control a workbook with a macro. I want to prevent people from saving to a new location. Is there a simple way to stop the "SaveAs"?

If not, I can write code to check the path in the...

Thanks. That works, as does autofit, if I don't have any merged cells. Once the merged cells are in the mix the behavour changes.

Check to see what other events you have associated with the text box. Your code should work.

the exit sub is not needed, the if statement will suffice, but the code works either way.

I tried...

Use "Exit". Set Cancel to true to stop the cursor from exiting.

Private Sub tbOne_Exit(ByVal Cancel As MSForms.ReturnBoolean)
If tbOne.Value <> "1234" Then
tbOne.Value = ""
...

I am automatically inserting text into some cells. I want to have the cell height adjust automatically to fit the text. I do not know how to determine a proper fit via code. I do know that ...

You have some good advice, but also consider the old fashion way, the command prompt.
The command is

rename myfile.jnk myfile.exe

(assuming you are in the directory where the file is located)

I figured out what I wanted. It is not as fancy as the DB properties window, but it will suffice.

Right click on a shape, select shape, custom properties. In the pop up dialog, select define,...

If I start a new visio document as a "Database Model Diagram," when I add an entity shape it has a properties page at the bottom of the screen. I would like to add properties to other shapes, not in...