This subject is not trusted for the specified action

Outlook 2003.  Try to add a Rich TextBox (Microsoft Rich Textbox =
Control, version 6.0 C:\WINNT\system32\RICHTX32.OCX) to a Userform in =
Outlook 2003 VBA.  The error is "This subject is not trusted for the =
specified action."  How do I fix this?  Thanks.

Windows 2000 SP3 Microsoft Office 2003 Microsoft Internet Explorer 5.5 =
SP2 Microsoft Visual Studio 6.0 SP5

George Hester
George Hester
12/23/2003, 4:25:13 PM

3 replies
The same problem with Rich Textbox is also true for Excel 2003, creating a major problem for us with our cost-estimating models used by the U.S. military and Pentagon.  Attempting to put a Rich Textbox on a VBA form in Excel 2003 results in the message, "This is not a trusted object for this action."  If anybody knows the answer to this problem, please let me know, Lawrence Jerome, Technomics, Inc.  (email: l*********
1/7/2004, 2:06:19 AM Try this one man I think it'll work.

George Hester
"Lawrence Jerome" <l*********> wrote in message =
> The same problem with Rich Textbox is also true for Excel 2003, =
creating a major problem for us with our cost-estimating models used by =
the U.S. military and Pentagon.  Attempting to put a Rich Textbox on a =
VBA form in Excel 2003 results in the message, "This is not a trusted =
object for this action."  If anybody knows the answer to this problem, =
please let me know, Lawrence Jerome, Technomics, Inc.  (email: =
George Hester
2/16/2004, 11:57:06 PM
"George Hester" <h***********> a �crit dans le message news:
O******************2MSFTNGP11.phx.gbl... Try this one man I think it'll work.

George Hester
"Lawrence Jerome" <l*********> wrote in message
> The same problem with Rich Textbox is also true for Excel 2003, creating a
major problem for us with our cost-estimating models used by the U.S.
military and Pentagon.  Attempting to put a Rich Textbox on a VBA form in
Excel 2003 results in the message, "This is not a trusted object for this
action."  If anybody knows the answer to this problem, please let me know,
Lawrence Jerome, Technomics, Inc.  (email: l*********

4/6/2004, 12:58:13 PM

overtime during weekdays and weekend ( more specified)
2 replies , 6/24/2008, 8:08:35 AM

Specifying chart graph
1 replies , 9/14/2006, 1:23:01 AM
How can I specify on the same chart which fields I want to be displayed as Column and which fields I want to be displayed as Line? I have over seven fields. Let's say I want columns B through E to be columns and the other columns to be lines. Thanks in advance.

Hi I have been using a excell sheet with out any problem for several month, but suddenly one member in the group can't save the excell file. He get's the following message: "System Error &H8007007E (-2147024770) The specified module could not be found" Followed by a message: "Out of memory". Can anyone help me out here? They are all running Excell 2003 SP2 /Steen

Specify format in source data
1 replies , 5/6/2004, 8:43:31 PM
can you specify format information in the source data. for example coul you specify that a segment in a pie chart for sales of oranges shoul always be orange, apples green etc et -- Message posted from

lynxbci <
How to specify cell ranges dynamically?
5 replies , 6/7/2006, 7:51:11 AM
Hi, I was wondering how I may do the following? I have data in several columns. I have calculated a value from these columns and this sits in a cell, say G5. This value dictates how many rows I need to sum up in Column H, say. Is there any way that I can put a formula in a cell which looks something like "=SUM(C <ROW()>:C <ROW()+G5>)" ? I.e. sum in column C from the current row to the current row plus the value in G5????? Thanks Dave -- Agent Wild ------------------------------------------------------------------------ Agent Wild's Profile: View this thread:

Agent Wild
The specified network name is no longer available
7 replies , 11/25/2006, 2:29:51 PM
Hi All, A customer has SBS 2003 SP1 at the Head Office and Server 2003 R2 at a Branch office. All shared data is on HO server. The BO server routes requests from BO users to the HO server. RRAS on the BO server provides NAT for the VPN link to HO server. BO users can authenticate on both servers, can see all shares on both servers, can print to printers on both servers and can copy large files back and forth between servers. The problem: If a BO user starts copying files from the HO server to the BO server and a second BO user starts copying files to (or even browses the contents of a share on) the HO server, the first users file copy immediately fails with "Cannot copy <filename>: The specified network name is no longer available". More Info: This happens on the customer's hardware and I get the same results if I simulate the topology using virtual servers and workstations. The file copy will succeed if the second BO user does not access shares on the HO server. After the error both BO users have full access to all shares and can start copying files again immediately. No errors are logged on either server or the workstation. Any assistance appreciated. Thanks. Branch Office Configuration: LAN NIC: IP Address. . . . . . . . . . . . : Subnet Mask . . . . . . . . . . . : Default Gateway . . . . . . . . . : DNS Servers . . . . . . . . . . . : VPN NIC: (To Head Office) IP Address. . . . . . . . . . . . : Subnet Mask . . . . . . . . . . . : Default Gateway . . . . . . . . . : DNS Servers . . . . . . . . . . . : WAN NIC: (to Internet) IP Address. . . . . . . . . . . . : Subnet Mask . . . . . . . . . . . : Default Gateway . . . . . . . . . : DNS Servers . . . . . . . . . . . : Adaptor Binding Order: LAN Connection VPN Connection WAN Connection Head Office Configuration: WAN NIC: IP Address. . . . . . . . . . . . : Subnet Mask . . . . . . . . . . . : Default Gateway . . . . . . . . . : DNS Servers . . . . . . . . . . . : LAN NIC: IP Address. . . . . . . . . . . . : Subnet Mask . . . . . . . . . . . : Default Gateway . . . . . . . . . : DNS Servers . . . . . . . . . . . : VPN NIC: (from Branch Office) IP Address. . . . . . . . . . . . : Subnet Mask . . . . . . . . . . . : Default Gateway . . . . . . . . . : DNS Servers . . . . . . . . . . . : Adaptor Binding Order: LAN Connection VPN Connection WAN Connection

Paul Close
Specified Cast is not Valid
1 replies , 1/13/2004, 3:07:25 PM
Sorry about the cross-post but I am in a bit of a bind. I am developing an Add-in for Visio 2002 using VS.NET and I am having trouble getting a reference to an excel worksheet object that exists on the page. Here is the code I am having a problem with (doc is declared as Microsoft.Office.Interop.Visio.Document in the function parameters): sel = doc.Application.ActiveWindow.Selection '>> Works obj = sel.Item(1).Object '>> Works xlSheet = CType(obj, Microsoft.Office.Interop.Excel.WorkSheet) '>> Throws "Specified Cast is not Valid" exception MsgBox("Got sheet = " & xlSheet.Name) '>> never gets here I tried casting to a Workbook object but this did not work either. How can I get my worksheet object out of the obj variable? Thanks Calvin

which font format do i specify? ...
0 replies , 9/7/2004, 12:49:15 PM
anyone out there> can anyone please help shed a bit of light on which font format i should = be=20 specifying for two new, bespoke typefaces to be included within a new=20 corporate identity? i am wanting departmental administrators and secretaries using microsoft = office apps to be able to use the fonts as well as design professionals = (mac=20 based, probably) but need to know whether the fonts should be supplied = in=20 PostScript and TrueType or the newer OpenType format. i'm aware that OT is an adobe/microsoft joint venture, but which apps = and=20 operating systems can currently easily use the OT format? is the safest = bet=20 to specify PS/TT that can be handled by people using older kit and = software=20 (and desktop printers) or does the new OT format not make a difference = and=20 is just as easy to use as PS/TT? any help anyone can offer in this area will be greatly appreciated. cheers r<

Opening on a specified sheet
5 replies , 12/31/2003, 4:03:32 PM
I have 20 sheets in an excel document. Is there any way to have the document always open on a specified sheet. Thanks.

how to specify a range that is variable.
4 replies , 4/8/2008, 7:57:02 PM
I have a control variable sheet that has the "start" and "end" column numbers. For a number of different data ranges that us the same start and end columns, how do I specify the ranges in various formulas that would use the start and end column variables but different rows? Do I have to use VBA which I am not very good at? Thanks for any help. -- Mal

I have cells in a row with RGB values between 0 and 255. I'd like another cell to be shaded in the color specified by those three values. Can this be done with a macro? If so, what is the macro? Thanks. -Rob

Rob Miller
Program for specifying dimensions
2 replies , 7/20/2009, 5:52:11 PM
Guys, I am not able to get Visio right now. Is there a common desktop application where I can create objects to specific dimensions? For example, I need to create a rectangle where the bottom length is 30mm, the left height is 20mm and the right side height is 15mm. Thank you.

I am trying to use the text generated in a certian cell as part of a function which will reference the appropriate sheet and pull information from a certian row.

Lookup & Give Specified Info. in Specified column
1 replies , 6/8/2008, 3:14:00 AM
Hi, I have a file with 2 worksheets in it. The first worksheet, provides a list of charge numbers under a specified program. The second worksheet I am using for as a timesheet template. In the second worksheet, I created a list in one of the columns which finds the list of charge numbers from the first worksheet. What I would like to happen is once I pick one of these charge numbers, the next 2 or 3 columns "automatically" pull relavant information from the first worksheet & insert to specified cell. For example: Worksheet 1 - Tracking Charge # Sheet Column 1 Column 2 Column 3 Charge # PO XYZ Status 1234 PO 4444 Active Worksheet 2 - Timesheet Column 1 Column 2 Column 3 Task Charge # PO XYZ Status Pick from list Pulls Info. from 1st Job 1 of Column 1 from worksheet (Attempting to tracking that Job 1 is being billed or charged to its correct charge number I attempted a handful of formulas so far, but none of them seem to fully work yet. Please assist. Thank you....

Color Chart Columns to Color Specified by a Cell Value
0 replies , 7/23/2008, 3:27:14 PM
I want to create a chart with the color of the columns specified by a value in a cell. All of the columns can be of the same color. I am already using the code below to update the scale of the chart, using a value in cell E35 in this case. Is there something I can add to this to control the color or do I need to use a seperate piece of code? Sub UpdateScale() ActiveSheet.ChartObjects("Chart 4").Activate With ActiveChart.Axes(xlValue) ..MinimumScale = 0 ..MaximumScale = Range("e35").Value End With End Sub

I am making a tracking data base and I would like to make certain cells change color when a date in that row is beyond a certain time frame. This will be used to quickly identify overdue and upcoming events. Thanks in advance. Mike

LIST to a specified total
3 replies , 12/12/2003, 2:38:20 AM
I am copying a large number of tracks from CD's to audio cassettes. Given that I know the duration of each track, WHAT IS THE EXCEL FORMULA TO LIST THOSE TRACKS that will come clostest to, but not exceed, the length of the playing tape. For example, say I have: Track # Duration 1 16:48 2 21:36 3 33:36 etc etc I want Excel to produce a LIST of the track numbers that total closest to a tape duration of say 45 minutes. My further, but related query, is HOW TO SUM the duration column in a table such as above, when the figures are mm:ss (minutes and seconds). Many thanks.

Specifying a Range.
3 replies , 4/11/2007, 12:10:00 AM
Please bear with me. This is probably a painfully fundamental question. I need to specify a range of 48 cells in a sum formula. For example, =SUM(A10:A57). Is there another way to achieve the same results by subtraction? Something like, =SUM(The cell I want to end with - the quantity of cells)? Hopefully, the question makes sense. Any help would be greatly appreciated.

Charting only the specified dates
1 replies , 9/21/2004, 1:37:01 AM
Hi all, I am using Excel 2002 SP-2 on Win2k Prof. Q1. I have the following data for testing Date Val 20/09/04 2 21/09/04 4 22/09/04 8 23/09/04 16 24/09/04 32 27/09/04 16 28/09/04 8 29/09/04 4 30/09/04 2 And, when I simply chart it the chart shows missing dates on X-Axis, 25/9/04 and 26/9/04, with interpolated values each, according to either end of the closest values (24/9/04 and 27/9/04). Why does this happen? How can I turn this on/off? Q2. In relation to Q1, I try to create PivotChart and this time need interpolated values for dates not specified in PivotTable. How can I do this? Thanks for your time --- Tetsuya Oguma, Singapore

2 replies , 6/7/2006, 2:25:02 AM
I have a worksheet with 5 columns the first of which is simply an "item #". Essentially it's just a row # and keeps track of how many entries there are. The problem is when I sort the worksheet, it includes this first column and makes this info useless. So I want to sort the other four columns without affecting the data in this first column. Basically I want to specify the range. Can I do this?

Specified fields
3 replies , 4/26/2006, 11:54:48 AM
Hi Can you predefine options to fill in a cell. For example I only want people to able to choose. 01 - Annual Leave 02 - Sick Leave 03 - Study Leave Due to the fact it needs to be imported into another programs it needs to be spelt exactly like that, so I would like to specify them up front. Can anyone help -- Patsy Rogge

Patsy Rogge
Specify which .pst file to use when using activesync
1 replies , 5/21/2005, 11:54:01 AM
I have 2 pst data files - one is for my own use, and another is the family shared calendar and contacts, which we access from several computers in the house. How do I tell ActiveSync to only point to the family calendar and contact data file instead of the default pst file?

How do I delete specified times from a spreadsheet
1 replies , 9/5/2006, 3:32:01 AM
I have a spreadsheet that is using a nested array to add column L after meeting specified criteria in columns A and B. Columns H and I are times. Column L is the difference between H and I. What I am attempting to do is have column L calculate the difference only if the times are between 8:00 and 22:00 in column H. I would want the L column to show zero if the criteria is not met. I have used "MOD(I3636-H3636,1)" as the formula to calculate the time difference between H and I.

Specify dimensions for Excel charts
1 replies , 1/23/2006, 5:12:02 AM
It would be great if one could actually specify the dimensions of the axes of a graph, or the graph itself without eyeballing. Could ther for example be a function hat lets me set the lenths of the x and y axes to 4 inches by 4 inches. I do not want to esimate anything. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane.

specified server could not be found
1 replies , 1/5/2004, 8:13:36 PM
I'm receiving an error message when sending from my roadrunner account. Message is "specified server could not be found". When I use mac mail I don't have this problem. I'm able to receive mail from this account just can't send. Does anyone have suggestions on how to trouble shoot this problem. Thanks

Kent Wagerman
Open at specified page
1 replies , 3/8/2006, 2:36:36 PM
Is it possible to have a workbook open at a specific sheet - if so how would I go about it - I have a menu sheet with links to other areas of the w/book and would like the thing to always open at the menu. Thanks -- SD8146

Specifying Legend Entries
1 replies , 6/20/2005, 8:04:47 PM
Does anyone know of a way to either specify a range for the lengen entries or make a custom legend without usig a text box. When using text box, it is not WYSIWYG and is a problem to size properly fo printing. Because of the way the data varies, creating a separat series for each group of data representing legend entries isn' practical. Thank -- Joey Chart UserPosted from newsgroup acces

Joey Chart User
Application.GetOpenFilename from a specified directory
1 replies , 5/20/2008, 1:27:03 PM
Hello! I have Excel 2003 and I already have a macro to popup a open file dialog. However, it always starts at "C:\My Documents" folder. I want it to browse files to open from a specific directory. How is this done? Note that I already have the "ChDir" on the line above the "Application.GetOpenFilename" but the browsing does not start from the specified directory. Thanks in advance for your response.

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I want to search a worksheet for a value that matches the value in a specific cell then returns the contents of a cell related to the matched cell. Something like: <br> If B is the cell whose contents (a number) is equal to the contents of cell A, return the contents of C(B), where C(B) specifies a cell relative to B.

How to specify pie chart total?
2 replies , 10/18/2007, 6:55:02 PM
Hi guys, I'm sure this is me being dim but can you help. I have a worksheet showing a column of figures that each shows the number of different 'incidents' that have occurred. At the bottom of the sheet is the overall number of calls. Many calls do not become an 'incident'. Some calls can end up with two or more incidents. I'd like to create a pie chart showing the percentage of each type of incident - with much of the pie chart blank as many calls did not progress to becoming an incident. For the life of me I can't work out how to do this. I can easily create a pie chart that shows the split of percentages within incidents but I want to show how they all relate to the total calls. Do you see what I'm getting at? Hope you can help, Regards, Lee

Chart with specified x and y
1 replies , 1/3/2007, 11:14:48 PM
Hello, I have a table x where there isn't arithmetic progress. First numbers are: 100 150 200 .... 950 1000 (and then) 1100 1200 1300 .... 3000 and table y: 74 3478 346 4 ..... I want to make a chart with points in exact locations: (100,74) (150,3478) (200,346) When there is an arithmetic progress in table x, there is no problem (I just set etiquettes to cells with table x), but with the table x like above, it doesn't work. How can I do it? Thank you

Open eml and specify to-adress and subject?
0 replies , 2/25/2008, 7:49:05 PM
Hello, Is it possible to open a mail template (eml) and to fill the receiver-adress and the subject-line without using .NET or COM - just form the command line? If not, is it possible to write the mail-adress and the subject directly into the template to a temporary position, and open that? Thanks, Regina

Specify an Input file?
1 replies , 5/24/2004, 3:01:23 PM
What I'd like to have, is a system so that users can specify a .CSV t get some data from. Currently, my macro only will generate a Pie Chart from a variabl range of values, but as the data will come from a .csv file, i'd lik users to be able to specify where the data is coming from. Any ideas -- Message posted from

David Evans <
Specifying axis points
6 replies , 2/12/2004, 7:11:43 PM
Is it possible to specify which axis points I want to display in Excel? My problem is that I am charting a line graph and would like to display the zero point just slightly above the x axis. However, when I set my x axis to -.25 all of my y axis points adjust to this point (.75, 1.75, 2.75). Is there a way to readjust these or to set the y axis to whole numbers? I would like to see 1, 2, 3, ect. Thanks!