(c) Somehow discourage a buyer from emailing the full version on to others.I don't think I want to go down the route of sophisticated protection (activation and the like): I don't want to annoy honest customers or create a support nightmare.If no explicit converter is specified, the base converter is being applied, see Gets or sets the height, in points, of a Range.If all rows in the Range have the same height, returns the height.Raise Number:=vb Object Error ERR_NO_WINDOW_HANDLE, _ Description:="Unable to get the Power Point Window handle" Exit Property End If If Lock Window Update(hwnd) = 0 Then Err.Raise Number:=vb Object Error ERR_WINDOW_LOCK_FAIL, _ Description:="Unable to set a Power Point window lock" Exit Property End If Else ' Unlock the Window to refresh Lock Window Update (0&) Update Window (hwnd) hwnd = 0 End If End Property 'Sample Usage: Sub Long Processing Sub() ' Lock screen redraw Screen Updating=False ' --- Long time consuming code ' Redraw screen again Screen Updating=True ' Also see below article for another example of usage of the code End Sub It's fairly simple to open a Power Point file (*.ppt) for editing using VBA code however opening a Power Point Show (*.pps) file for editing is altogether another matter. Open method and it defaults to open the file in Slide Show mode. The routine below illustrates a manner of woring around the default behaviour and opening the file for editing.As a workaround, you could use a smaller data set while you are formatting the chart.
If no path is specified and if the file hasn’t been saved previously, it’s being saved in the current working directory with the current filename. For proportional fonts, the width of the character 0 (zero) is used.I have an Excel Add-In that I want to make available for sale.I'm hoping it can generate a little revenue while I'm working to bring a bigger and better product to market.Any suggestions on something quick, simple, and moderately effective that I could implement? Installing is actually non-trivial as you need to add it to a registry key - but the key depends on how many other addins they have installed. ) an installer at one point - I can look in there for what I did - I think it was basically iterate through the relevant keys until you find the next empty one...I wonder if there isn't something that you could do so that they just open up the addin and run a macro/menu item that then adds itself to the addins list through the Excel object model?