Disable VSTO toolbar when cell is being edited

Visual Studio Tools for Office

Windows Tech ‹ Office
- Archive
  - SharePoint
  - Game
  - Visual Studio
  - VC++
  - Architecture
  - Visual C#
  - Office
  - ISV
  - Windows Vista
  - VS Express
  - Dotnet
  - Windows Forms
  - VFP
  - VS 2008
  - VB
  - Windows Live
  - SQL Server
  - IE
  - Smart Device

- Previous
  - 1
    - Error - InfoPath cannot open the selected form Hi Lixinfeng, To resolve this problem I did: The Menu -> Tools -> Form Options -> Security and Trust -> uncheck "Automatically determine security level" and select Full Trust - >OK Att Tag: Visual Studio Tools for Office Disable VSTO toolbar when cell is being edited Office
  - 2
    - Multiple windows I've got an odd issue that I'm uncertain how to resolve. I'm running VSTO 2005SE with Office 2K3. I've added buttons to the toolbars that open windows. The odd thing is that when I click the button, it opens as many windows as there are powerpoint instances. I have no idea why a click in one instance causes the event to be run in all. I've tried setting it so that it checks to see if the window already exists but because they're being opened by separate instances, this does not work. Any recommendations would be appreciated. Thanks Denis --- www.21square.com Tag: Visual Studio Tools for Office Disable VSTO toolbar when cell is being edited Office
  - 3
    - NamedRanges in Excel 2007 with VSTO SE Thanks Sole for coming back to us and show how it's achieved with C# I hope I will be able next time to give it a try with C# Tag: Visual Studio Tools for Office Disable VSTO toolbar when cell is being edited Office
  - 4
    - MAPI.SessionClass in Outlook 2007 Hi, Previously, I work with Outlook 2003 and install CDO in my machine. This code snippet was work in Outlook 2003. MAPI.SessionClass session = new MAPI.SessionClass(); session.Logon("", "", false, false, Type.Missing, Type.Missing, Type.Missing); session.Logoff(); Recently, I upgrade to Outlook 2007 and found out that MAPI was not in Outlook 2007 anymore, may I know how to replace the code snippet above using Outllok 2007 API. Regards Kendy Tag: Visual Studio Tools for Office Disable VSTO toolbar when cell is being edited Office
  - 5
    - Outlook Appointments Sue, Thanks very much Tag: Visual Studio Tools for Office Disable VSTO toolbar when cell is being edited Office
  - 6
    - Add TaskPanes in Office 2003 Hi, I spend last day trying to find a solution to add customs taskpanes in office 2003, Is this possible I'm using vsto 2005. I founded that office 2007 has the CustomTaskPane property....but for office 2003 didn't find nothing. Bye, Pedro Rocha Tag: Visual Studio Tools for Office Disable VSTO toolbar when cell is being edited Office
  - 7
    - Support for multiple columns in Form Region controls Right, that's my point: In Orcas, you either use .NET controls or you use an .ofs file with olk* controls, which can be bound to Outlook properties, but you can't mix and match them in the same region. In VSTO 2005 SE, any ActiveX control in theory should work on a region page, but I've heard of people having some problems and it hasn't been done much, I imagine. I'd probably stick with the OlkListBox control if it were my project. Tag: Visual Studio Tools for Office Disable VSTO toolbar when cell is being edited Office
  - 8
    - WindowActivate not being called Thanks for your research Ji. I have Office 2000 and office 2007 on my machine as well as a test machine with 2000, 2003, and 2007 on it. However, it does not seem to matter which office I am using, my menu still does not get put up nor does the windowactivate command get called. Maybe the difference is my code is in VB6 with COM addins Could that be the issue Tag: Visual Studio Tools for Office Disable VSTO toolbar when cell is being edited Office
  - 9
    - building outlook toolbar in contacts okay ive done that now but i seem to be getting this error: "object reference not set to an instance of an object" and it seems to be caused by this line: myInspectors = (Ol. InspectorsClass )myApplicationObject.Inspectors; Tag: Visual Studio Tools for Office Disable VSTO toolbar when cell is being edited Office
  - 10
    - Before an Appointment item is saved, how can I get the occurrences specified by the recurrence pattern? The dt variable is of DateTime type - it does have a time part in it, although it was being set to 12:00:00 am. I tried adding a second to the variable before calling GetOccurrence, but the result was the same: Instead of returning nothing or the occurrence for that date, the same exception is thrown. What could possibly be going on with this item that would be causing this Tag: Visual Studio Tools for Office Disable VSTO toolbar when cell is being edited Office
  - 11
    - Outlook 2007 RTM FormRegion & InfoPath control Thanks for your reply (sorry I didn't see it sooner). The basic form region is made up of the standard to, cc, subject, and message fields and then an InfoPath control at the bottom. The form region is a "replacement" form as opposed to a partial region that exists in another form. Using the simplest repro method, have the add-in cause the InfoPath control to create a new form using a template (we open a File Open dialog to get the template but you can hard-code it for your tests). Once the form region (as its own form since it is a replacement form region) is open, you can tab to all of the controls except the InfoPath control. You can click (with a mouse) into a field in the InfoPath control, but if you press tab, you will leave the control and go to the next Outlook field. I believe you should be able to tab into the InfoPath control and then remain there until you click out of it (in other words, the InfoPath control should process all keys while it has focus). Let me know if you need more information. Pete Loveall Tag: Visual Studio Tools for Office Disable VSTO toolbar when cell is being edited Office
  - 12
    - Conditionally create multiple MS Word documents based on a single, master MS Word doc? I want to conditionally create multiple MS Word documents based on the same master MS Word document. Example: I have a single MS Word document with say 100 sections. I want to create 4 different MS Word documents, which include a different subset of the sections from the master document. I know I can do this today by manually copying and pasting, but this is error prone and time consuming. I am looking for a solution where I can somehow tag the different sections in the master document and then somehow provide a parameter value which indicates which sections (based on their associated tags) should be stripped and which should be kept in the resultant document. I experimented with the MS WORD mail merge feature - but it's insuffience to archieve the above result. Please let me know if the above can be achieved with the vanilla MS WORD product, and if not what commerical Word add-ons do you recommend Tag: Visual Studio Tools for Office Disable VSTO toolbar when cell is being edited Office
  - 13
    - VSTO 2005 and VS 2005 Pro - how to get all features of both Sorry if the answer is already out there and obvious but I can't find it and need to make a purchasing decision: I'm using VS 2005 Team Suite Trial Edition. I don't need all that this version has to offer. Basically I want VS 2005 Pro with full VSTO capabilities. I understand that VSTO SE will help but doesn't offer full capabilities. I also need the capabilities in VS 2005 Pro that aren't in the VSTO version. From a purchasing standpoint the most cost effective way to go seems to be to buy VS Pro with MSDN Pro subscription to get both. Does this make sense Thanks in advance for your information. Tag: Visual Studio Tools for Office Disable VSTO toolbar when cell is being edited Office
  - 14
    - outlook toolbar in sent messages Hi all, i have created a toolbar that loads a commandbar into outlook when it loads, using Code Snippet Office.CommandBar newToolBar; Office.CommandBars cBars =this.Application.ActiveExplorer().CommandBars; newToolBar = cBars.Add("myBar", Office.MsoBarPosition.msoBarTop, false, true); (with some other stuff), and it loads into the main outlook screen fine.... However, I would like to have these buttons in the toolbar when I open up a message. i.e. open outlook, open a message, press toolbar button. HOw do I install the button/toolbar into that screen thanks michal Tag: Visual Studio Tools for Office Disable VSTO toolbar when cell is being edited Office
  - 15
    - Creating a formatted Microsoft excel file. Thanks for all your messages.. Let me give the full details to my problems. I'm leaving Office 2007 out of the picture.. So, lets say Office 2003 will be available at the max. You say VSTO is for Office 2007. So, maybe i can't use it... Thanks coz' i'll look into it anyway. Cheers. Tag: Visual Studio Tools for Office Disable VSTO toolbar when cell is being edited Office
  - 16
    - Printing Range of Pages prints in a 20 page document, prints it 20 times It is a 20 page document. object pageRange = "1,3,5,7,9,11,13,15,17,19" object PrintRangeOfPages = Microsoft.Office.Interop.Word. WdPrintOutRange .wdPrintRangeOfPages; object PrintDocumentContent = Microsoft.Office.Interop.Word. WdPrintOutItem .wdPrintDocumentContent; object PrintAllPages = Microsoft.Office.Interop.Word. WdPrintOutPages .wdPrintAllPages; Document .PrintOut(ref BooleanTrue, ref MissingValue, ref PrintRangeOfPages, ref MissingValue, ref MissingValue, ref MissingValue, ref PrintDocumentContent, ref pageRange, ref PrintAllPages, ref BooleanFalse, ref MissingValue, ref MissingValue, ref BooleanFalse, ref MissingValue, ref MissingValue, ref MissingValue, ref MissingValue); Please advise if I am doing something wrong. shrini Tag: Visual Studio Tools for Office Disable VSTO toolbar when cell is being edited Office
- Next
  - 1
    - Deploying Visual Studio 2005 Tools for Office Second Edition Solutions Using Windows Installer (Part 1 of 2) Thanks, Douglas, that makes me feel a little better. I had assumed that everyone else knew exactly what the article was referring to, and that my own background as an Office vba developer was the problem. BTW, do you know if there is any reason to use the older SDK that you referenced as opposed to the one found here, which seems to be newer http://www.microsoft.com/downloads/details.aspx FamilyId=0BAF2B35-C656-4969-ACE8-E4C0C0716ADB&displaylang=en Tag: Visual Studio Tools for Office Disable VSTO toolbar when cell is being edited Office
  - 2
    - How to store meta-data in Outlook 2007 I am developing an Outlook plug in where I have to store meta-data in Outlook for the customizations user does. How to store meta-data in Outlook without persisting to the user (and) without storing in different file(like xml file) I did research on table object. But, I think it doesn't help me out because it is read only object. Please let me know if u have any ideas I am using VSTO SE/ Outlook2007 /VS 2005/C# Thanks, Rama Tag: Visual Studio Tools for Office Disable VSTO toolbar when cell is being edited Office
  - 3
    - A strange problem in retrieving a file path and creating a button in Word Hello Avi, here you cfan find the ComShimWizard wich is used to create a COM AddIN wich loads your .Net AddIn. http://msdn2.microsoft.com/en-us/library/aa537166(office.11).aspx So I read that you get it working - what was the solution Greets, Helmut Tag: Visual Studio Tools for Office Disable VSTO toolbar when cell is being edited Office
  - 4
    - Word automation from a Web Service Brain, Your project seems interesting. I am working on a project where we also need to automate word report generation on the Server. However I do not know how having the word documents as VSTO objects helps Also I do not know how you do NOT need to have word installed on the Server We were initially looking at having Word Projects (VSTO Approach) but since we did not want each word doc to be compiled in a dll , we went the Word Interop approach. We have about 330 word templates with bookmarks. Since Installation of word on server is not recommended , we are know looking at PDF solution. However I found that even Adobe Acrobat 7.0 Professional and using Acrobat SDK is not licensed and recommended for server if we go with PDF Templates and xml data. However I am interested in finding out how with using Word 2003 Word documents templates with bookmarks ( to hold data) and using Interop based solution can we go with Server based solution using xml and without installing word on server I can get the document data in xml format. Basically I am interested what is needed for your soluton that you mention to work. Our templates currently in Word 2003 with bookmarks. Requirements : Merge Word 2003 Templates with bookmarks with Data from xml Print Word 2003 Document from Server. Save as PDF also ( currently I have GhostScript API to do this ....Word to PostScript file and PS to PDF using GhostScript API ) Any help would be greatly appreciated. Tag: Visual Studio Tools for Office Disable VSTO toolbar when cell is being edited Office
  - 5
    - Deployment path setting Hello, I've developed an addin for Word 2007 using VSTO 2005 SE. For the setup file, I'm using the default setup file when I created the project. My question is, how can I set a default installation folder for my addin For example:- When the setup file launched, I want to make the *.msi file to automatically install the addin to a predefined folder. It means that no user interaction required, no need to choose an installation path and no clicking needed. Just a direct installation like the MS Office 2007 PIA msi setup file. Can it be done Hope someone can help me about this. Regards, Westman Tag: Visual Studio Tools for Office Disable VSTO toolbar when cell is being edited Office
  - 6
    - Adding images to home-made context menus Hi, Please check this KB link : http://support.microsoft.com/kb/288771 Thanks Ji Tag: Visual Studio Tools for Office Disable VSTO toolbar when cell is being edited Office
  - 7
    - Adding a large amount of contacts I've hit a road block. I am writing a .NET Outlook (2003) plugin to update my users contacts from a database that our clients update. I have managed to get the plugin button up, and clicking on the button gets the contacts and starts adding them. However, the code has added the 249th contact item, I start getting First Chance exceptions. Is there some kind of restriction that stops me from adding more contacts This is a huge issue for new users in the group, becuase we have over 5000 email address that need to be pushed out to the Contacts Folder. Here is my code for adding the contacts. Please tell me if I am doing something wrong or if there is a restriction: foreach ( DataRow dr in dt.Rows) { try { Outlook. ContactItem ci = (Outlook. ContactItem )newcontacts.Items.Add( Outlook. OlItemType .olContactItem); ci.CompanyName = dr[ "CustomerName" ].ToString(); ci.FullName = dr[ "ContactName" ].ToString(); ci.CustomerID = dr[ "CustomerNumber" ].ToString(); if (dr[ "ContactNumber" ].ToString() != "" ) ci.BusinessTelephoneNumber = dr[ "ContactNumber" ].ToString(); ci.Email1Address = dr[ "ContactEmail" ].ToString(); ci.Save(); } catch ( Exception ex) { Console .WriteLine(ex.ToString()); } Tag: Visual Studio Tools for Office Disable VSTO toolbar when cell is being edited Office
  - 8
    - Attaching custom actions Pane to all documents !!! Hi All, After reading quite a few posts and trying out various shortcuts or hacks to acheive an " Application Level Task Pane " for Word 2003, i have really come to a grinding halt !! few of the paths that i followed were 1. Tried to modify the XML of a WORD document by adding the _AssembleName=* and _AssemblyLocation custom document properties.... I am now trying to acheive this by Attaching Managed Code Extensions to Documents...still work in progress i guess my question would be that in one of these posts Misha Shneerson did point out that it was possible to attach a task pane at an Application level but could only be acheived by someone like her who knows the internals of ActionsPane and VSTO and that it wasnt for the *****Faint Hearted***** .... still trying to locate that post... so if any one could point me in the right direction or suggest an alternative, that would be great !!! I know that Custom Task panes are possible in word 12/ 2007... but i def. require to achieve this with word 2003 / Office Pro edition... as our target audience is not likely to move to office 2007 for quite some time !!! If i haven't been clear please do ask for clarifications !!! tha, koms Tag: Visual Studio Tools for Office Disable VSTO toolbar when cell is being edited Office
  - 9
    - Convert a selection and convert it to rtf Hello all, Is there any way to take a selection from MS Word using VSTO, and convert that selection to rtf Right now here is the code which uses the clipboard: private string ConvertToRTF(Word. XMLNode node) { string strData = "" ; try { // Copy to clipboard (This will erase the clipboard contents that the user entered into here before!!! node.Range.Copy(); strData = Clipboard .GetText( TextDataFormat .Rtf); Clipboard .Clear(); } catch ( Exception ex) { Trace .WriteLineIf(logic.ASI3Reporting.TraceError, "Error converting to rtf: " + ex.ToString(), "Errors" ); string ss = ex.ToString(); } return strData; } The problem with the code is that the clipboard contents are now replaced with my selection thus replacing the value at the top of the clipboard stack so the end user won't have their original copied data. I need to copy this because this is the only way that I can get the selection converted to rtf. Another method would require saving the entire document to disk as rtf but this would only work for the entire document, whereas, I need to convert only a selection. Any help would be greatly appreciated. Tag: Visual Studio Tools for Office Disable VSTO toolbar when cell is being edited Office
  - 10
    - ComboBox on an Outlook PropertyPage doesn't seem to get DrawItem events Interesting! At least it's not an Outlook limitation then. I've modified my code so use Items.Add instead of setting the DataSource and the problem remains. Here is the current code: Code Snippet // in init comboBox.DropDownStyle = ComboBoxStyle.DropDownList; comboBox.Items.Add("Test 1"); comboBox.Items.Add("Test 2"); comboBox.Items.Add("Test 3"); comboBox.Items.Add("Test 4"); comboBox.DrawMode = DrawMode.OwnerDrawFixed; comboBox.DrawItem += new DrawItemEventHandler(comboBox_DrawItem); private void comboBox_DrawItem(object sender, DrawItemEventArgs e) { MessageBox.Show("Draw called!"); } Tag: Visual Studio Tools for Office Disable VSTO toolbar when cell is being edited Office
  - 11
    - ServerDocument.AddCustomization throwing COMException HRESULT: 0x80040407 Why not write an external "upgrade" utility that just updates all the current documents your client has Why even mess with that whole: "Open document, intercept before OTKLOADR, etc..." Since you know you want to migrate these documents ... just migrate them outside of Excel and everything else ... Just a thought. Tag: Visual Studio Tools for Office Disable VSTO toolbar when cell is being edited Office
  - 12
    - Support for multiple columns in Form Region controls Right, that's my point: In Orcas, you either use .NET controls or you use an .ofs file with olk* controls, which can be bound to Outlook properties, but you can't mix and match them in the same region. In VSTO 2005 SE, any ActiveX control in theory should work on a region page, but I've heard of people having some problems and it hasn't been done much, I imagine. I'd probably stick with the OlkListBox control if it were my project. Tag: Visual Studio Tools for Office Disable VSTO toolbar when cell is being edited Office
  - 13
    - Error when trying to install ClickOnce Application Howdy, I'm trying to install a clickonce application from IIS on my development machine which has .NET 3.0 installed and VS2k5 sp1 installed. When I navigate to the site and click the Install button I get the download dialog and all is well until I select run from the the setup dialog. I then get the error below: The following error occurred attempting to install 'http://luke/ArlTexAjax/AddressBook.application': "Application not found " I have set the MIME types for .application, .manifest and .deploy extensions. As I was working trying to solve this issue I noticed if I clicked on "launch" link on the installation page, the install is accomplished successfully. It seems as though the setup.exe file cannot find the AddressBook.application file which is in the same folder with the setup.exe file. Can anyone give me a clue or two regarding what may be going on here Tag: Visual Studio Tools for Office Disable VSTO toolbar when cell is being edited Office
  - 14
    - Unlocking a project... What's wrong with that forum Been there. Researched that. Found no solution. Wrong Oh, I'm sorry. I thought 'Tools for Office' meant Tools for Office. It's free It's not wanted. A solution is what's wanted. Since you seem to know all about this place, point me to the right place, Dennis. But don't point to the other Office forums... OK so You can perhaps handle it but what about other who take part of the solution. I can't be responsible for anyone else's actions but my own. I would like to think people would be responsible with good information, but that would be nieve. Besides, there are plenty of Excel cracks out there and if I was really after a crack, why would I come here I would go some place else for that rather than try to program my own. Crackers (not hackers) are lazy and wouldn't go through that much effort. Or do You believe we have a private conversation in a public thread. Do you realy think I'm that unintelligent I'm gritting my teeth because the last thing I want to do is start an arguement on a Microsoft website! That would be dumb. If you have an answer you would like to keep out of the public domain, I would be more than willing to keep the conversation private to avoid misplacement of potentially dangerous information. I just don't understand why you have to be so difficult. I said in the beginning to point me in the right direction (other than where I had already been) if this was indeed the wrong place to be. If you have any other resources, please post them. Thanks. Tag: Visual Studio Tools for Office Disable VSTO toolbar when cell is being edited Office
  - 15
    - Properties on outlook2003 folders Hello I have a question regarding user properties and MAPIFolder object. In the Outlook 2007 object model I can do something like this, Outlook.MAPIFolder folder = explorer.CurrentFolder; folder.UserDefinedProperties.Add("myUP",Microsoft.Office.Interop.Outlook.OlUserPropertyType.olNumber, missing, missing); In the Outlook 2003 object model I do not have that possibility, (no folder.UserDefinedProperties property). What is the best way to attach custom properties to a folder in Outlook 2003 Tag: Visual Studio Tools for Office Disable VSTO toolbar when cell is being edited Office
  - 16
    - word range to html? thanks for the reply. the clipboard sounds like the right option for me but i can't make it work... i seperate parts of the word documents into different objects (i have a special class for that called Section). each section has a few parameters and a Range which is the range from the original word document that contains the data for that section (the data can be anything from text, images, table, etc..). i need to transform this data into html, so this is what i did: Code Snippet m_text.Select(); m_text.Copy(); if ( Clipboard .ContainsText( TextDataFormat .Html)) Console .WriteLine( Clipboard .GetData( DataFormats .Html).ToString()); else Console .WriteLine( "no good: " + m_text.Text); (m_text is the Range object) all of the sections give the same result: "no good: " + the text of the section (the text is the right text). what am i doing wrong it looks like the content of the range does not go into the clipboard... thanks a lot! Tag: Visual Studio Tools for Office Disable VSTO toolbar when cell is being edited Office

sameera

When you start typing in on a cell, Excel 2003 disables some standard toolbar buttons. How can I achieve the same effect for my VSTO toolbar buttons. I've looked for an event such as ThisWorkbook.CellStartEdit, but there seem be be none that matches what I'm looking for.

Thanks.

Re: Visual Studio Tools for Office Disable VSTO toolbar when cell is being edited

Peter Jausovec

Hi,

There's no such event in ThisWorkbook. But there's an event called Change on sheet level (e.g. Sheet1, Sheet2, ...), maybe you can put it to use somehow.

Re: Visual Studio Tools for Office Disable VSTO toolbar when cell is being edited

sameera

I've used Change event for something before, and it fires after the user has finished editing (by hitting Enter or Tab). What the problem here is that people click on the toolbar buttons without finishing the edit. Some of these buttons trigger code that reads the current cell and when the cell is not committed (editing completed properly), this throws memory read exceptions or behave unpredictably. So I just want to prevent them from clicking on the buttons without exiting the currently editing cell.

Re: Visual Studio Tools for Office Disable VSTO toolbar when cell is being edited

Dennis Wallentin

It's not possible to track when Excel goes into edit mode and it's not possible to execute any code when Excel is in edit mode,

I believe that the closest solution is to use the Worksheet_Change event where You check if the active cell is within the Target address, If so the code should disable the wanted buttons.

Re: Visual Studio Tools for Office Disable VSTO toolbar when cell is being edited

sameera

Sadly this is not an option.

If the toolbar was disabled when the cell range was entered, that defeats the whole functionality of the toolbar. And if the toolbar action wasn't dealing with the current active cell, probably the memory read errors will not happen either.

Excel disables toolbars when the user starts typing. Why isn't there a way for us to od the same