Setting font properties using function
I want to be able to set the properties of a cell font using a function.
I have tried the below but it errors in the function with
Error Number: 91
Error Description: Object variable or With block variable not set
Anyone not on holiday out there who can help me please!
happy new year
xlSht.Cells(1, 1).Font = NameFormatType1(255)
Private Function NameFormatType1(NmCol As Long) As Excel.Font
NameFormatType1.Color = RGB(NmCol, 0, 0)
NameFormatType1.Bold = True
Try these changes
Sub...can't select field in view to move or set properties
Ever had this problem? Got to be the strangest thing. Well, I found the
answer and have to give credit to Mitch Milan's blog and apparaently Nithya
Balasubramanian for finding the problem.
The problem is when customizing a view you can't select a field to move it
to the right or left or edit the width. Here is the answer:
In case this link doesn't work the answer is simply and quite strangely
adding about:blank to your trusted sites or to the local intranet site
depending on what zone your crm ...Booked locked for editing properties
How do you set the properties so that whoever is in a workbook and you get
the message "...locked for edtiting" Isn't there a way that each person from
their computer can put there name or identifier in?
Normally setup during intial run of XL. To change it:
Tools - Options, User Name
"RFW" <RFW@discussions.microsoft.com> wrote in message
> How do you set the properties so that whoever is in a workbook and you get
> the message "...locked for edtiting&q...Open ports for IMS-properties
At a customer of ours a NT4-server (SP6a) is hosting Exchange 5.5 (SP4).
After enabling the security in de Network-properties we have troubles
opening the IMS-properties in the Exchange Administrator. The ports i have
opened are 443, 80, 8080, 21, 110 and 25.
Can anyone tell me which port to open to resolve this problem and leaving
security on on the NIC?
Hi there Michel,
This site http://www.mcpmag.com/columns/article.asp?EditorialsID=149
contains a list of ports and the services behind them.
Hoop dat je zo geholpen bent ;)
Jeroen van Reenen
&...Exchange DoS vulnerability due to possible named properties overflow
Here's a problem. Exchange Server 2003 has a hard quota limit for the named
properties of the messages stored in Exchange Information store, as
described in a KB article 820379. After the quota has been reached, numerous
error messages with Event ID 9667 and 12800 from MSExchangeIS are generated
in Exchange server's Application Log. This creates DoS conditions for the
affected Information store. If the quota is increased up to the capacity
limit of the named properties table (32,000), server can become unresponsive
to client requests.
Named properties quota overflow can be...Shape properties
I have created a drawing of our server racks. I have also gone into the
custom properties of the shapes as they are laid out in the racks and I have
entered the server names, serial numbers, BIOS versions, etc. of each shape
and I want to display it in a table on a master list sheet. How do I do
I know the data is usable, I just don't know how to effectively display it.
Have you considered starting with Tools => Reports => New???
"Mark Hauschild" <email@example.com> wrote in message
&...Implementing a window like .NET Studio's "Properties"?
Does anyone know if there's a class available to make a Properties-type
dialog with .NET studio in C++? I'm looking for what pretty much amounts to
a 2 column grid, with the ability to put edit boxes, combo boxes, etc. into
the right hand column.
Thanks for any tips.
you can use the propertygrid control.
"cada0310" <firstname.lastname@example.org> д����Ϣ����:79284EE3-B397-4098-B168-B4D7A69D6776@microsoft.com...
> Hi there,
> Does anyone know if there's a clas...Reading properties from closed book
I am trying to read the last date saved from closed workbooks. I
downloaded the ReadPropertyFromClosedFile from Chip Pearson's site and
selected the DSO OLE Document Properties Reader 2.1 reference. I do
not understand the formula syntax. I thought it should be:
but it always returns #NAME?
Windows 2000 & Excel 2003
...Ability To Change Entity Properties After Creation
If you create a custom entity without allowing activities to be related and
later decide that you need activities, you have to recreate the entity and
loose all your data. We need to have the ability to after creation, change
that property. Once turned on, you would not be able to turn it off, but you
should be able to turn it on after creation.
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, follo...Updating custom properties on multiple shaoes
Is there any way to change the custom properties (not the data values, but
the "custom properties properties") on all instances of a certain shape in a
Visio file? I know I can select all instances of the shape on any given page
and change the properties, but I have hundreds of instances of a certain
shape spread across maybe fifty pages, so whenever I find out there's a
property missing its a gargantuan task just going through all the pages
look at updating the master.
view - drawing explorer window
Select your master and edit.
All this cou...Reg hiding such parameters in the properties of the mail #2
I am using the outlook 2003 client for sending the email. when it reaches
the destination end, the destined user is easily identifying the parameters
like, from where the mail is coming like, public ip, machine name, and local
ip address of the system which the mail is originated.. so i do not want to
publisize such parameters to the outside world.. so how would i adjust the
oulook such a way it should not take such parameters while sending the
i shal be thankfull if u help me on this!
thanks in advance
<email@example.com> wrote in message
news:#8ikqBqv...personalize OrgChart template, stencil and master properties
I need to adapt the OrgChart Template to get the following features:
1. need to make custom properties to master shapes (so that they are
availables each time i drag and drop a master from the stancil to the
drawing). This means two things: first remove the default built-in
properties (name, title, email, etc), and second add my own properties. I
want ONLY my own properties on masters!!
2. need a custom stencil (based on the OrgChart stencil) with master with my
custom properties defined at point 1.
3. On the masters' istances on the drowaing I want to display my own custom ...Excel Properties
When using the File menu pull down screen I dont see the Properties options
which I need in order to get to the properties dialog box.
Have you exposed all of the menu options by clicking on the circle with the
double-v's at the bottom of the menu?
> When using the File menu pull down screen I dont see the Properties options
> which I need in order to get to the properties dialog box.
Or better still, get rid of that 'facility' by going to
Tools>Customize>Optiosn and uncheck the Menus show recently used commandbars
&...Exchange 2003: modify contacts properties
Hello to all:
I�m a University student who is doing a project where I�m
administrating a Exchange 2003 Server. I would like know if I could
add new properties to the contacts estored on the server.
Thank you very much,
...Shortcut Properties dialog
A simple request, but one for which I can find no specific answers.
How does one call up the Shortcut Properties dialog for a given link file? That is,
the dialog that appears when you right-click a shortcut and select Properties.
Thanks in advance,
Take a look at the following KB article
How To Invoke the Shell's File Properties Dialog Box
Check Abdoul [VC++ MVP]
"Brian Banks" <firstname.lastname@example.org> wrote in message
news:%23hcpkPkzEHA.3708@TK2MSFTN...Dialog Editor shows blank properties window
I have a dialog based application in which I have a few
buttons and Edit Controls. Everything was ok and now all
of a sudden when I click on the Button and check the
Properties the properties shows up as empty. I am using
Visual Studio .Net. It happened to me before, and I
reinstalled the Visual Studio .Net and it seems to have
worked fine. But I am hoping I dont have to reinstall it
Any suggestions as to what can be done in this case.
...change link properties in a cell
Our accounting software creates an excel report that contains a link
to an image. (file://H:\xxxxx\xxxx\xxxxx.tif) for example.
The problem is we want to replace the path to the image with something
that will point to a folder on a dvd for example. We will not be able
to control which drive letter the end user will use.
My questions then;
Is there a way to change the path in the link without interacting with
each one? There are well over 1000 links in each spreadsheet.
Is there a way to make the new path relative to the location of the
Thanks so much,
Perha...XmlSerializer would not serialize properties in the class derived from List<T>
I have following 3 classes
public class MyMainClass
MyCollection<MyObject> m_oMyObjectCollection = null;
private string m_sID = string.Empty;
public MyCollection<MyObject> Collection
this.m_oMyObjectCollection = value;
public string ID
...Show file properties when opening a workbook
Looking for a way to display a message box that displays file properties
(date created, modified, last accessed etc.) when opened.
Any ideas would be greatly appreciated.
Put this code in the ThisWorkbook code module. There is no last access
propertyt to show I am afraid.
Private Sub Workbook_Open()
MsgBox "Author: " & .Item("Author") & vbCrLf & _
"Date created: " & .Item("Creation Date") & vbCrLf & _
"D...Shape Data versus Properties?
Is there a difference between Shape Data (found by right-clicking a shape,
highlighting "Data" and then clicking "Shape Data") and Properties (found by
right-clicking a shape and then clicking "Properties")?
No, it's just a different way to access the same data.
"Jason Freeman" <email@example.com> wrote in message
> Is there a difference between Shape Data (found by right-clicking a shape,
> hi...Access 2007 form properties
We just upgraded(?) to Access 2007 and the first thing I have come
across is this:
I have a simple continuous form where the query is based on the value
in the control 'box_district'. 'box_district' is in the form header.
I have the detail of the form hidden until 'box_district' gets
updated. This code bombs at the asterisked line but it is because the
detail does not become visible as it should based on the third line.
Was something changed that would prevent 'me.detail.visible = true'
Private Sub box_district_AfterUpdate()
...Modify Edd/Add Record/Deletion Properties of Form and Child Subfor
I have a form and a correlated sub-form. I want to prevent the data enterer
from modifying the form unintentionally when he clicks a check box
"Completed". I tried some simple VBA in the "Completed" control's "On Click"
property but it had the effect of also freezing the user out of un-checking
the same control if the need were to arise later on.
What's the right way to approach that? Anyone?
If it's a thing of being able to uncheck the box when needed, you can place a
button on the form to have it unfreeze the checkbox when clicked. ...TextColumn Properties of ComboBox
When I scroll through the contents of the combo box (ListFillRange set for
two columns) I see the information from both columns. But, when I select the
row I want only one column of information is shown.
I've played around with the Bound Column and TextColumn, but that is only
allows me to switch which column of the two is shown.
Is it possible to have the whole row show in the box after it's clicked?
...Changing a forms properties under program control
I have a form caled "frm _Main" and that form has a Sub Form called
"frm_Sub_Address" embeded in it. I am wanting to make the "frm_Sub_Address"
get its information from two different Tables depending on what info the user
wants. The two Tables are called "tbl_Stores" and "tbl_Suppliers". I know
that you will raise the question, why do I have 2 tables containing Adddress
info but putting that pointy to one side for the moment, my code is as
follows, depending on what info the user wants :-
iF user wants this info
For...List Properties of WLM Contacts
My current list of WLM contacts (when clicking on `contacts' in the pane) is
shown as Last Name first, then First name, then E-mail address, reading the
columns from left to right. And I can change those around or go from A-Z to
However, when I create a new e-mail and click on `To', the contacts listing
comes up with `First name, followed by last name (in one column) then E-mail
address in the column to the right.
Inside a new e-mail I'd like to have my contacts come up (after selecting
`To') to be Last name, first name, then e-mail address. Is there anywa...