Search:

You answered an earlier post in part by suggesting that I check the "file dirty flag" to see if a workbook had been updated. I'm afraid I am too stupid to figure out which property this is and how...

Ah, I see. That should work. Thanks.

Do you mean that I would highjack the normal File/Save or SaveAs etc.? Build my own main toolbar? Seems like a lot of work to recreate all that. And a little dangerous if they open multiple...

I create and destroy my toolbar every time the workbook is opened/closed as the folks on this site have suggested. Works very well, except if someone clicks "cancel" when they are asked if they want...

thanks, Sam.
The information is very detailed and exactly what I need to know. The only problem is that it doesn't exactly fit with the more modern dialogs, but it will certainly help me figure it...

<img src=/S/bow.gif border=0 alt=bow width=15 height=15>
Thanks Legare and Andrew. I leaned about how to display the file dialog without opening the file (Application.GetOpenFileName), how to turn...

Andrew, I tested your solution and it worked beautifully. However, it dawned on me that I have multiple copies of the application already in the field, so I cannot change the way the open macros...

This is the code I use to open the old workbook (with data to be imported into the new workbook):
Application.Dialogs(xlDialogOpen).Show
This pops a nice dialog, and I can proceed with no trouble. ...

I develop apps for clients. Those apps get enhanced over time. I've built in an "import" macro that allows a client to import an old version into a newer one, eliminating the pain of reentering all...

As an example, I wanted to use the file open dialog, and thought perhaps if I set the parameter to read-only to true, it might not trigger the open macro so I wouldn't get an unwanted form displayed....

Is it possible to read the data in a workbook using VBA without opening it? If so, is there an xldialog like the xldialogopen that would allow my user to choose which file to deal with without...

I've always been disappointed by the sparse information on xldialogs in excel help. Nor have I seen them detailed anywhere in the many books I have. Where can I find details on using the xldialogs,...

My program imports data from one workbook into another. I use xldialogsopen to pick the file to import from. This all works except that I have an on-open macro that fires off in the import file. ...

I create the toolbar from scratch, so I don' think there are any phantom hidden buttons. I could pause between creation of them, but I don't understand why that would work. If it crashed all the...

w2000,O97. I have a large workbook that includes many macros. I create a toolbar on the fly. Sometimes when I save my workbook, it crashes with one of those ugly "cant read memory at x%$#!"...

Well, I answered my own question this time: I can just check the selections. Thanks your help, all of you.

Thanks for your input. I think you are exactly right that there are three different menus that MS uses based on context of the selection. Do you know of any way for me to test which context I am in...

Andrew, did you mean that the actual SiteMapSetMenu program needs to be in the worksheet area rather than a module? If so, that is peculiar, as it always works the way I have it now EXCEPT when I...

In the module for the worksheet I use:
Private Sub Worksheet_BeforeRightClick(ByVal Target As Excel.Range, Cancel As Boolean)
Call Module1.SiteMapSetMenu
End Sub
I do not have any charts, so...

my code adds eight new options to the shortcut menu on this worksheet whenever there is a rightclick event. If I right click anywhere but on an "entirerow" selection, it shows what I want: the MS...

w2000,office97. My right click menus seem to get reset if I click a selection that spans an entire row. How to I stop Excel from performing this reset? I tried cancel=yes, but that kills the...