macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need a crash course on macro and forms,
Specific thing I need to know how to do is to create a sheet that gives me
the specific salesperson on a specific zip code when entered on the zip code
blank field.
It should also have the salesperson's phone numbers/emails/cell associated
with each zip code query.
I also need to create another sheet with product part numbers associated
with a description and price list, when a part number is entered or vise
versa.
HOW ????? I'm panicking.
 
For the row height question.............

Open a new workbook. Customize as you wish.

For the autorun macro.............

Right-click on the Excel logo at top left next to "File" and select "View
Code".

Copy/paste this code in there.

Private Sub Workbook_Open()
' your macro code or name goes in here
End Sub

ALT + Q to go back to Excel window.

File>Save As Type: scroll down
to Excel Template(*.XLT) and select. Name your workbook "BOOK"(no quotes).
Excel will add the .XLT to save as BOOK.XLT.

Store this workbook in the XLSTART folder usually located at........

C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART

This will be the default workbook for File>New>Workbook.

Existing workbooks are not affected by these settings.

You can also open a new workbook and delete all but one sheet. Customize as
you wish then save this as SHEET.XLT in XLSTART folder also. It now becomes
the default Insert>Sheet.

More can be found on this in Help under "templates"(no quotes).


Gord Dibben Excel MVP
 
Back
Top