I need to write-protect one o more cells , but i need that this cells can be
selectec.
Because i need the activecell address for a macro.
i'll appreciate any help.

Hi,
I'm a newbie at pivot tables, but have been asked by my boss to create one
for a bunch of end users who are even less computer literate than him!
My pivot table is set up and ready to go, but I have 4 possible "value"

The same range needs to be printed for one or sometimes more sheets in a
workbook.
This *should* be easy, but can't seem to make it happen properly.
Can anyone please correct the following code apppropriatlely?

The following code is extracted from a larger routine which purpor is to
print/convert an xls into a pdf.
   sFileFullname = Mid(strFilename, InStrRev(strFilename, "\") + 1, 255)
'get full filename

I have a combobox populated with fractions that display properly.
After selection the fraction converts to a decimal, but the list
values are still fractions.  How can i display the selected value as a
fraction?

I snagged this beautiful piece of code from here, and I've seen other
code that could do it, but I'm having a hard time gluing it all
together. Is there any way I can make this:
---start code---

I have a worksheet with one column which contains numerous GL account
codes suchs as:
001-400010-00-11000
001-400010-00-12000

I want to generate a list in excel using a simple form.
-------------------------------------------------------
Start Range:<TEXT BOX>
End Range:<TEXT BOX>

In a worksheet, I have borders around cells C5 and E8 and F4 and each cell in
D15:G19.
When I run:
Sub next_tryx()

Using VLOOKUP or MATCH, if my Lookup Value is greater than 254 I get
#Value!.  This is obvious a limit in Excel 2003.  Is there a way around
this using other formulas or even VBA.
Thanks,

I'm using the following for a series of comboxes to display the dd
list when the combobox is selected (using tab as opposed to mouse
clicks).
Private Sub ComboBox2_Enter()

I have several UserForms my users use in a workbook.  For some reason some of
my users are only seeing portions of the labels.  For example, my computer
will show the label caption "Description", but another computer may show
"Descr", why is this?

I've seen many posts using one column and how to use the advanced
filter but I don't think you can use them with two columns of info.
My s/s (often +1000 records) has col C LastName & col D FirstName with
other supporting details e.g. address, email of stakeholders. Many

I have 10 tabs that I will need to rename from a textbox (not the range in
the code below).  The following code has to be ran first, then backtrack to
rename the appropriate tabs to the value in the textbox.  Anyone have any
ideas?

I am trying to program Excel 2007 with VB.NET in order to plot 100 graphs in
one worksheet. I would like to know if there is any way to declare the graphs
as an array, like:
Dim MyPlots(99) as Chart