I have a Dell Dimension 2400 computer that I want to install a new larger master hard drive. The computer currently has a 30GB hard drive. I would like to remove the 30GB hard drive, reformat, and use as a slave on an older computer.
Will I be able to reinstall the XP operating system that...
I have a website that I created with FP2003 that shows our product line. Each item gets it's own page. I would like to display the selling price for each item on it's respective page, but have it linked to a database so that I can update prices via the database and not have to go to each page...
I have a website that shows our product line. Each item get's it's own page. I would like to display the selling price for each item. Can I set up a database to do this with FrontPage? It seems that future price increases would be easier to update one database file rather than having to go to...
Can a layer be contained within a cell of a table using FrontPage 2003?
I have a table 2 rows x 3 columns (fixed width at 800pixels). The top row is merged, the bottom row has a menu in the left cell, a picture in the middle cell, and text in the right cell. Is there a way I can add a layer to...
Area G10:AP122 has it's cells filled with a simple formulas like =K8*6. The formula in the cells always references row 8 (Quanity Required) in their respective column. The *6 can vary from cell to cell, it is not a fixed value. The problem is I should've written the formula(s) as =$K$6*6...
Hello,
First off let me start off by saying I have no knowledge of AutoCAD other than being able to print out a drawing. Our in-house guy that does our CAD drawings has a somewhat limited knowledge of AutoCAD 14 that we use. My basic question is, can dimensions be calculated based upon user...
I have a worksheet that has a drop down list with 6 choices. I would like a graphic (jpg, gif or bmp)to appear on the worksheet that matches the choice selected in the drop down list. Is this within the capabilities of Excel?
I'm wondering if this is possible to do in Excel. We make bookcases and would like a quick way of creating "cut sheets" based on the sizes of bookcases on order. I can get our sales order program to export into excel a list of bookcases on order, model numbers in column A, and quantity on order...
Not sure if this is an SBT or SBS fax server issue. All works well when I manually enter the receipientfax number when using the SBS fax server, but if I use the address book to select a fax number, after clicking on "finish" to begin the faxing process, the following error message appear from...
In Cell B1, my formula is ="Traditional Bookcase (Flush Cut $"&(ROUND(F1*10),2)&" per side)")
F1 has a multiplier the user enters, F1 is formatted as a number with 2 decimal places.
Depending on the number I enter in F1, I get answers that vary in length, I would like them to always appear...
I have an order form, column 1 is quantity, column 2 is item number, column 3 is description, and column 4 is cost. Columns 3 and 4 are automatically filled in using VLOOKUP. I use Data Validation in column 2 so that the part number must be typed in correctly. We have about a thousand different...
I am using FrontPage 2002. I found a template for creating a discussion board in the FrontPage wizards. Is it possible to add an image upload capability? That is, we want the users to be able to post a message and if necessary upload a picture that can be seen below the message.
Also, I didn't...
When using the following:
ActiveSheet.Protect Password:="my password"
Is there someway to set it up so that only unlocked cells can be selected?
Thanks,
Raymond
How can I delete a custom toolbar that I have created on the close of Excel? I have a macro that saves as , closes the saved workbook, and opens the original workbook. I need to delete the toolbar when Excel is closed so that it only appears when my user is working with the file I created for...
I have the following code so that the file save name will be the contents of cell B1, plus the date and time:
SuggName = Left(Sheets("PO").Range("B1"), 5) _
& ("_") & Application.Text(Now(), "mmddyy") & "_" & Application.Text(Now(), "hhmm") & ".XLS"...
I have 4 columns, A is quantity, B is part#, C is description, D is cost, E is my extended cost and all together about a thousand rows worth of product information. The user inputs a number in column A. I then run the following so that only those rows with a qty appear:
ActiveSheet.Unprotect...
I found the following in Excel VBA Programming for Dummies.
Sub GetPrice()
Dim PartNum As Variant
Dim Price As Double
PartNum = InputBox("Enter the Part Number")
Sheets("Prices").Activate
Price = WorksheetFunction. _
VLookup(PartNum, Range("PriceList"), 2, False)...
Whenever I apply Autofilter to an area, a small drop down arrow icon appears at the top of the column, is there anyway to not have this appear? The autofilter is applied by a macro activated by a button, and I don't want the user to accidently further filter the results.
Thanks,
Raymond
This is my first time ever using a macro, so I'm not sure of what's possible or not. I have an Excel spreadsheet with 4 columns, Column A is quantity, Column B is item code, Column C is item description, and Column D is item cost. I have placed a button on my sheet that uses the code found...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.