Search:

Since Excel does not have a delete or add row event is there some coding techique that will inform that a row has been deleted or added?

I have an outlook folder under my mailbox and this folder has a link to a home page on the home page tab. I want to send a copy of the folder to another person or persons so that they can add it to...

I have installation of Word 2007 Pro with all SP on it. Whenever a Word document is open including a new blank one the Error proofing comes on and keeps running (the animated icon appeasr in the...

How would one find text that has a hyperlink assoicated with it (blue underlined text) like in a Word document?

Thank you both for the help!

Using VBA trying to find text that is also a URL wiithin a body of text. I assume the URl is astyle or something like a style that could be searched for but haven't dscovered the method or property,...

If you are doing this in an add-in, then:

Me.Application.OnKey("^{s}", "") ' Ctrl+S Save

(note: your code was actually re-enabling the shortcut!)


Thank you Rory. Yea I did figure-out on my...

I have used the following code to disable short-cut keys via VB6 Code but the same code does not work in .NET (VSTO) .NET 3.5 SP1

Excel.Application.OnKey "^{s}" '...

Is XML the only way to disable a command, group, etc. in Excel 2007 via VBA? I have an Excel workbook that needs to work in Office 2000 - 2007 and when in 2007 disable some ribbon commands but of...

Thank you Rudi.

Using VB6 I am currently using thre common dialog object (comdlg32.ocx) to create a dialog to naviagate to a word doc, select it and then use the "documents.open" method to open the file. Is there a...

Attached is a zip file with a word addin that creates a custom toolbar named LSI. The toolbar is not pretty and it performs standard word functions like indenting, bullets, etc. why someone did this...

Thank you pieterse Don's material helped us.

Is there a way to disable a group on a ribbon via code?

Thank you Pieterse and Hans for confirming what I thought it was. Some in y department were thinking that sections of VBA code in a file can be signed while others sections are not.

(Edited by HansV to make URL clickable - see <!help=19>Help 19<!/help>)

What exactly is a Macro Project (http://office.microsoft.com/en-us/help/HP052495551033.aspx)? Is this like a XLA in Excel...

Thank you Pieterse that solved the problem!! For Word I have to do the same except use "menu bar" only as the index for CommandBars. I looked at various books on Excel programming and none of them...

I keep running into problems accessing menu items using the menu ID number rather than the menu name. Here is another problem using the ID when using it with the OnAction

The following works in...

Thank you Hans. The enable was a typo. Based on your reply I see now I can also use ThisWorkbook.Application.CommandBars.FindControl(ID:=30095).Enabled = True . Why the need for the application...

The following line in the ThisWorkbook class fails returning an error message that an object is not set. Adding ThisWorkbook to the watch window says it is out of context. The 30095 refers to the...

Ok I am slow but I figured it out

ThisDocument.CommandBars.FindControl(Id:=30002).Enabled = False Actually Hans answered a similar question I had posted on this subject but I am slow about...

I think I know how to do this and will re-post or in a few minutes.

On a foreign language version of Word like french the following code line fails since File, Send To, etc does not exist on a French version.
ThisDocument.CommandBars("File").Controls("Send...

We have a right click menu event and based on where the cursor is located at the moment of the right click a different default meu appears. We want to add our custom menu items to the end of the...

Is there a way to catch when a row or column is being added or deleted on a sheet? The Worksheet_Change event does get fired but I am not sure what property to look at to know that a row or column is...