I teach Excel and we go through a customize the environment
(Tools/Options/General-Username), Add-Ins, Customize toolbars and menus, etc.
So I recorded a macro to see what would stick and I only got the General
Options and Addins, not reset customized toolbars or menus; Any ideas ...

i try to send a mail from excel but my problem is the attachements:
.Attachments.Add "C:\THOMAS_PIRON\Scan_Charleroi.pdf"
.Attachments.Add "C:\THOMAS_PIRON\texte_Charleroi.pdf"
etc...

in my form i have 2 textboxes that i'm trying to link.
for example:
textbox1= code
textbox2= disciption

[This followup was posted to  and a copy was sent to the cited author.]
G'day there One & All,
    I'm back on the group with a question again, but this one's more
for curiosity than for need.

How can I keep the columns in a textbox when I copy from a worksheet. If I
just copy/paste, the text is not aligned in columns?

Pressing Problem!
I've tried for the pass four days to figure out a way to obtain
information from two ranges and present the results either in a
separate userform or on the worksheet.

i have written a function which i want to use
whereever i need to use in excel
how can i save such macro?

i have very little excel experience,  i have a spreadsheet with a few
large columns (of numbers)
I need to divide each cells amount by 8.  Is there a way to reference
the cell itself and divide the original value by 8?  Alternatively, but

I created a macro. In the macro was a formula. When I run the formula it puts
single quotes around the cell position.
ActiveCell.FormulaR1C1 = "= (g2*(h2/100)*I2)/360"
In the Cell -- See g2-h2-I2

Hello, I've sure appreciated the help that I've gotten and found on this sight.
However I have a small problem.
I am wanting to Clear a range "j29:q38" on several sheets when a workbook
opens. The sheet names vary and can increase or decrease in number. I do have

I am looking to email an excel sheet using a vb macro. The reciprient's
email address needs to be copied from a cell in the sheet. This sheet
can either be sent as an attachment or sent within the email. Can
anyone help with vb examples.

Hey folks,
I'm working on a data automation project for PowerPoint.  In PowerPoint, I
give the user the option to create a new Excel chart and then drag and drop
it onto the PowerPoint form.

Hi, please me with this task.  I need to Find "Jan" then keep deleting
the columns to the left until "Jan" is situated in column B.
For example, "Jan" is in column E.  Find "Jan" then delete columns to
the left and keep deleting until "Jan" is on column B.

I need to find code that will resize a column based on the pivot row's field
name.  
Say I have a pivot field named "Long Name" and each time I use it for a
pivot it autofits to an enormous length.  I need a macro to check each

WHEN I USE THE LOOKUP FEATURE I CAN ONLY IMPORT ONLY ONE LINE INTO MY RESULT
COLUMB. I WOULD LIKE TO BE ABLE TO FILL IN MORE THAN ONE COLUMB WITH THE
RESULT LIKE THE WAY ACCESS USES THE LOOKUP AND FILLES IN MORE THAN ONE COLUMB
WITH RESULT. CAN IT BE DONE?