Password Protect

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Excel
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Missing characters when printing I'm using Excel 2002 and when I print a worksheet characters 's' or 'S were missing in certain words even though it turned out alright o print preview. Can someone assist me with that? I tried shutting down or reseting bu it's still the same. Appreciate any assistance. :confused -- Message posted from http://www.ExcelForum.com Tag: Password Protect Tag: 37918
  - 2
    - finding duplicates hi i've a list of 200 phone nos. in cell E1 to E200 and the list continue to grow. I want a WARN message everytime i enter a phone number that is already in the list as "Duplicate Phone Number". Kindly help reg deepak Tag: Password Protect Tag: 37917
  - 3
    - Top N list with "all others" Greetings all, I wish to evaluate a list of customers. I have 500 orders from approximately 30 unique customers. I wish to create a list such as "Top Ten" and then place the remainin 20 or so in a row called "All others" and have their count noted. In my Pivot Table I have a row field called "customers" and the dat field is "Count of customers" For those of you that are "Intuit Quicken" users you might know what mean. When you graph expenses, the top 10 categories are shown wit the last category being called "All other" with this one being a su total of all the categories not in the top 9. Example: Customer A 10 orders Customer B 7 orders Customer C 5 orders Customer D 2 orders Customer E 1 order Customer F 1 order Customer G 1 order I want to be able to generate a report showing Customer A 10 orders Customer B 7 orders Customer C 5 orders Customer D 2 orders All others 3 orders Thanks to al -- Message posted from http://www.ExcelForum.com Tag: Password Protect Tag: 37915
  - 4
    - Macros How do I create a macro? Tag: Password Protect Tag: 37908
  - 5
    - Finding Formula? I need to create a formula that will set a value from a table. For example, I have these data on Sheet 1: ID Name 01 Mark Anthony 02 Test Sample 03 Example Test 04 Beta VHS On Sheet 2, I have the same table but I need to type only the name on one column and the ID is automatically indicated on the same row. I have tried the Lookup function but I can't make this run. Please help. Mark Tag: Password Protect Tag: 37907
  - 6
    - Pop Up comment not popping up All of the sudden my pop up comments stopped working. In fact my macros have errors and everything is wigging out. Does anyone have any suggestions on what to try? Thanks, Julie ** Posted via: http://www.ozgrid.com Excel Templates, Training, Add-ins & Software! http://www.ozgrid.com/Services/excel-software-categories.htm ** Tag: Password Protect Tag: 37906
  - 7
    - INDEX and MATCH formula problem Hi all, I have this formula which I am using to match a value un Sheet1 against the first section of the value in Sheet2. This is the formula: =INDEX(Sheet2!A1:E10,MATCH(A4,LEFT(Sheet2!A1:A10,6),0),1) In Sheet1 the value is OP02.10000R and in sheet it is OP02.10000R.104. It only works if i take off the OP02. at the beginning. What do I need to do to my formula to make it work. Your help is greatly appreciated! Thank You ** Posted via: http://www.ozgrid.com Excel Templates, Training, Add-ins & Software! http://www.ozgrid.com/Services/excel-software-categories.htm ** Tag: Password Protect Tag: 37905
  - 8
    - Auto fill-in more than one column with words Hi, the problem I have is this. Let's say you have three columns. Country, Currency, Company. If I fill in the country column "Japan", is there a way to have i automatically fill in "Yen" in the currency column? Also - if the company is already filled in - is there a program I ca create or run that will go through thousands of lines of data so tha it auto fills in "Japan" and "Yen"? Lastly, for programs like this, are these classified under VBA or Macr or something else? Greatly appreciate the answer as I am having difficulty locating it -- Message posted from http://www.ExcelForum.com Tag: Password Protect Tag: 37903
  - 9
    - Data entry problem Hey there I just spent a few hours trying to come up with a solution t a problem I am having. The problem is this. I have two exce spreadsheets that need to be merged. The issue is that one of th sheets has more info then the last. An example is this Sheet 1 Subject Markers Tested Markers Complete Markers Concordant VT1081 24 21 21 VT1119 24 24 24 VT1169 24 24 5 VT1481 24 20 20 VT1538 24 24 24 VT1903 24 24 24 VT2089 24 24 24 Sheet 2 Subject Subject A: ApoE Subject B: ApoE VT1081 3/3^ 3/3^ VT1119 3/3^ 3/3^ VT1169 3/3^ 3/4^ VT1228 3/3^ VT1387 3/3^ 3/3^ VT1481 3/3^ 3/3^ VT1538 3/3^ 3/3^ VT1666 VT1785 3/3^ 3/3^ VT1903 3/3^ 3/3^ VT2089 3/3^ 3/3^ As you can see there are more subjects in sheet 2 then in sheet 1 and want to add the info of sheet 2 quickly and easily to sheet 1. I there anyway of doing it other then just picking and choosing the inf that I can copy over? :confused: Thanks for your time. : -- Message posted from http://www.ExcelForum.com Tag: Password Protect Tag: 37891
  - 10
    - Backing up EXCEL My EXCEL Files are (I think!) all in My Documents. I can back up My Documents to a CD, which includes EXCEL Files. But is there a better way to back up EXCEL? Tag: Password Protect Tag: 37890
  - 11
    - WORD vs. EXCEL: How to Optimize Hi all... I have a fairly complex spreadsheet that also incorporates lots of legal text. The app allows reps to enter info about prospects, and it computes pricing, generates legal documents, and other info. Clearly, EXCEL handles the math, but is weak with text. Depending upon certain inputs, different blocks of text may be used. Ideal world: utilize the best of both. Question: should I make this a WORD_centric document or an EXCEL-centric document, and how to set up the links between the two. Many thanks... /Randy Tag: Password Protect Tag: 37887
  - 12
    - E-mailing Workbook This may be more correctly an Outlook problem and if so then please accept my apologies for being off topic but it only happens in Excel not Word so I am thinking that it is a setting in Excel that is causing it. One particular user at my work attaches a workbook, (XL 2002 on Windows XP), by simply clicking on the paperclip and the XL workbook. When the (various) recipients opens the attachment it opens, (after a longer than normal pause), and then the e-mail header, (To, CC, etc.), appears between toolbars and the sheet. Clicking on the e-mail button on the toolbar hides/deletes the e-mail header, as does selecting View > Toolbars > Customize. Clicking the toolbar button again, (or exiting Customize), brings the header back. The user used to be able to send attachments normally and she says that she has not altered any settings - as she says "I 'm not experienced enough to alter things" - this just means that she wouldn't know if she did. I can't find any setting that she has changed - I cut my teeth on XL95 so that just means that I am not experience enough on XL2002 to know what I am looking for! Does anyone know what could be causing it. I will be grateful for any suggestions, Sandy -- to e-mail direct replace @mailintor.com with @tiscali.co.uk Tag: Password Protect Tag: 37886
  - 13
    - Protecting hidden columns so they can't be unhidden ? Hi, Is there a way to hide columns so that no one else can unhide them ? Need to send a file with data in 2 hidden columns that I don't want to be unhidden and I don't want to have to delete them. Thanks ! Tag: Password Protect Tag: 37873
  - 14
    - Protected Worksheet Indication Is there a way to visually see if a worksheet is protected? The toolbar will indicate protected cells but I cannot find a way to indicate whether a worksheet is protect without manually checking. Is there a formula that can be used in conditional formating of a cell that could indicate if a worksheet is protected or not. I need a quick way to know that required worksheets are protected. Thanks Steve Tag: Password Protect Tag: 37867
  - 15
    - Tab Name Is there a simple function to return the sheet/tab name of a worksheet... In office 2000 I had to use: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) But I believe that there is something more straight forward now, but I don't remember what it is. -- Thanks, Martin Schmid, EIT, CCSA, MCDBA, MCSE Tag: Password Protect Tag: 37857
  - 16
    - Excel Inserts Extra Rows In Text File When I open a certain text file either with the macro listed below, o from windows explorer, Excel inserts a blank row between each row o data. Is there some setting that can be changed to correct this? Any assistance would be appreciated. Sincerely Jim Palmer ChDir "J:\" Dim Filter As String Dim Caption As String Filter = "All Files (*.*),*.*" Caption = "Select a File" SelectedFile = Application.GetOpenFilename(Filter, , Caption) Workbooks.OpenText Filename:=SelectedFile, _ Origin:=437, StartRow:=1 _ , DataType:=xlFixedWidth, FieldInfo:=Array(Array(0, 1) Array(3, 1), _ Array(7, 1) _ , Array(11, 1), Array(29, 1), Array(40, 1), Array(53, 1) Array(59, 1), _ Array(66, 1), Array( _ 79, 1), Array(92, 1), Array(98, 1), Array(112, 1), Array(125 1)), _ TrailingMinusNumbers _ :=Tru -- Message posted from http://www.ExcelForum.com Tag: Password Protect Tag: 37856
  - 17
    - advanced filter information into a combo box for selection I have extracted information using a macro with worksheet_change If Target.Address = "$b$25" Then 'calculate criteria cell in case calculation mode is manual wsData.range("t2").Calculate wsData.range("PartsDatabase") _ .AdvancedFilter Action:=xlFilterCopy, _ CriteriaRange:=wsData.range("t1:t2"), _ CopyToRange:=range("C25:G25"), Unique:=False End If I want that information to be part of a combo/list box so that the customer can choose it as part of their order based on criteria they are searching for. I know there is a way.. but I just can't find where I found the solution once before. Kind of like searching by material, then because there are many of the same type of material.. filtering out just those records that meet the criteria and have them appear in the combo box where the user can then choose from just those records that appear. Thanks in advance for your assistance. Tag: Password Protect Tag: 37852
  - 18
    - Modifiable propagation time of Excel's functions? Hello, Does Excel, by any chances, allow for determining the propagation time of its functions? I am doing a project in which I need the logical operators to return their values after a certain predetermined period of time (e.g. the AND operator to return the value it computes after e.g. 1 second). Thank you very much for your time. Student P.S. If the answer is in the negative, what is the way to achieve it indirectly? Tag: Password Protect Tag: 37851
  - 19
    - Modifiable propagation time of Excel's functions? Hello, Does Excel, by any chances, allow for determining the propagation time of its functions? I am doing a project in which I need the logical operators to return their values after a certain predetermined period of time (e.g. the AND operator to return the value it computes after e.g. 1 second). Thank you very much for your time. Student P.S. If the answer is in the negative, what is the way to achieve it indirectly? Tag: Password Protect Tag: 37850
  - 20
    - Multiply two series and add results I have a large workbook with many sheets for each charge number on a project. I had to copy and paste a sheet into the workbook and am trying to remove the links to the original workbook. I have, in addition to the sheet for each charge number, a sheet with pay rates for each person. I need to multiply two columns of information together: the hours for each person * the pay rate for each person. The formula that was in the sheet (and on every single other sheet in the chart) is this: =SUM(C3:C24*'Costs'!$C3:$C24) (With 'Costs' being the sheet with payrates on it.) This formula produces valid answers for everysingle sheet in the workbook except for the one that was copied and pasted. I have tried several variations to this formula, with quotes and without, with dollar signs and without, extra parentheses, etc. Nothing seems to work. I have also tried copying the formula from another sheet in the workbook (where it does work) and I still get #VALUE for my answer. It says "A value used in the formula is of the wrong data type". However, they are numbers. They are formatted as 'accounting' with no decimal. (The same format as all the other pages.) I can't seem to figure out why this formula comes up invalid. Also, in a group of rows just above this error, I have a similar row, multiplied by the price of each individual person. And this formula is identical to the one I'm using just below, but refering to another series on the costs sheet: =SUM(C3:C24*Costs!$C29:$C50) I have noticed that some of the formulas, when I click on the cell looks like this in the formula bar: {=SUM(C3:C24*Costs!$C3:$C24)} However, as soon as I click in the formula bar to edit, the outside {brackets} disappear. I have tried manually placing them in the formula for this problem row - and it just makes the formula appear as text entered. How do I get rid of this error?? Please help!!! Thanks, Laurie Tag: Password Protect Tag: 37849
  - 21
    - Formula For Adding Variable Number Of Cells Required How can I get Excel to add up the components of each invoice in a lis where the total of each invoice is one made up of any number of smalle sums? For example, I could have invoice numbers 1 to 3 in Column A and thei sums in Column B: Invoice number 1 could have 3 sub entries of 5,6,7 (in cells B1-B3) Invoice number 2 could have 1 sub entry of 4 (in B4) Invoice number 3 could have 5 sub entries of 3,4,5,6,7 (in B5-B9) I would require Column C to have at the last entry of Invoice 1 (C3 the sum of 18; at the entry of Invoice 2 (C4) the sum of 4; and, at th last entry of Invoice 3 (C9) the total of 25. Apologies if this is a little(!) complicated but I have tried t simplify it as much as possible and if anyone can help, I'd be gratefu as doing the calculations manually for 200 invoices takes hours. Thank -- Message posted from http://www.ExcelForum.com Tag: Password Protect Tag: 37848
  - 22
    - Get day question My last question was answered fast and correct THANKS! If I have a cell that has the date d/m/y how can I have the next cell auto fill with the correct day? |05-14-2004| Friday| Thanks again Jeff -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 100,000 Newsgroups - 19 Different Servers! =----- Tag: Password Protect Tag: 37833
  - 23
    - Help with time subtraction This is probably a basic question, but here it is anyway. The 1st cell I want start time, 2nd cell finish time, 3rd cell will be the difference in the first to cells in #hours # minutes, or even decimal hours. | 8:00 AM | 1:30 PM | 5 hrs. 30 min.| Thanks Jeff -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 100,000 Newsgroups - 19 Different Servers! =----- Tag: Password Protect Tag: 37803
  - 24
    - help with cell This is what I am trying to do.... In cell A1, i have a figure I want to duplicate this in B1 In B1 i put =A1, and it reads "=A1" Also tried `Auto sum` but that just prints the formula in cell B1. Have never had a problem with this before but can`t work out what I am doing wrong.The worksheet is protected but I have tried unprotected with the same result. Is it maybe something in formatting? help appreciated. thanks Tag: Password Protect Tag: 37802
  - 25
    - Named Formula Problem I like to put calculations that are used in more than 1 place in a Name so that if I need to change them I can just change them in one place. However there is one calculation that will not work when it is referred to by name, always returning the #VALUE error. Exactly the same calculation in a cell works perfectly. The calculation is : -SUMIF(INDIRECT(ADDRESS(RowFirstData,COLUMN()+1)&":"&ADDRESS(ROW()-1,COLUMN( )+1)),INDIRECT(ADDRESS(ROW(),COLUMN()+1)),INDIRECT(ADDRESS(RowFirstData,COLU MN())&":"&ADDRESS(ROW()-1,COLUMN()))) RowFirstData is a name containing =ROW(Accounts!$A$3) Any ideas? Pete Tag: Password Protect Tag: 37798
- Next
  - 1
    - Summing sets of numbers but with special conditions Hi - I need a formula to do the following. I have 2 columns of six numbers - for example: A B 1 75 70 2 83 69 3 80 72 4 84 67 5 95 83 6 93 80 The formula needs to do the following: 1. Find the lowest number in column A (75 in row 1 in the above example) 2. Discard the number in corresponding cell in column B (70 in cell B1) 3. From the remaining numbers in column B, discard the highest (83 in cell B5) 4. Add together the remaining 4 numbers in column B (69, 72, 67, 80) and add this result to the number found in step 1 (75) to give a total (363) Any ideas/pointers most welcome. Thanks Tag: Password Protect Tag: 37796
  - 2
    - Formatting cell problem Hi, I have a column which I've converted from the default format to numeric. Upon doing so, most of the cells in that column display their contents as left-aligned, while the rest display their contents as right-aligned. While this may not seem significant, when I try to import this table to Access, the cells that are left-aligned cause a Type Format Error (as if they're not numeric). I've gone back and double-checked both types of cells (left/right-aligned) in this Excel column, and all show up as being numeric. Does anyone know what could be my problem here? Thanks, Aaron Tag: Password Protect Tag: 37789
  - 3
    - SUMIF functions Can anyone help with my problem what i want to do is add up the tota for a given criteria in a column when it meets conditions of two o more other columns -- Message posted from http://www.ExcelForum.com Tag: Password Protect Tag: 37788
  - 4
    - Summarizing tabs Summarizing tabs I'm looking at a spreadsheet with about 15 tabs where each tab name is relatively long so that I can only see about 3 or 4 tabs at a time even if I expand that part of the scrollbar. Is there a way to get a list of all the tabs? I guess I could dive into VB but I'd rather not. Thanks -Ed Tag: Password Protect Tag: 37780
  - 5
    - excel solver addin hi all i'm trying to use the excel solver addin from a C# windows application (that's going to be converted later to an add-in itself) and i haven't been able to do so. can someone please help me out thanks in advance Tag: Password Protect Tag: 37777
  - 6
    - macro recorder For some reason when I invoke the macro recorder (Tools/Macro/Record a New Macro) I do not get the accompanying tool bar with the "Stop recording" button or the the "Relative" cell reference button. Is there some setting in Options that needs to be set or do I need to re-install Excel? Jim Carter Tag: Password Protect Tag: 37775
  - 7
    - oops, can you get back a "save as"? Hi, I was asked to help out with a clerical error that lost an excel spreadsheet. What happened was, she accidentally performed a "save as" after deleting a lot of data in preparation for a new version of the sheet. So now it's either find it somehow, or re-enter the data. Is there a way to undo a save as? TIA Tag: Password Protect Tag: 37765
  - 8
    - Import all data as TEXT? Hi all... Long-time lurker here. On a regular basis, I need to import large data sets into excel that are CSV or fixed-width files. A number of the columns in these files get 'jumbled' by Excel if I don't set the appropriate columns to be imported as 'text'. My question is: Is there a way to tell excel to import/open *all* columns in a give file as text automatically? Some of these data sets have a lot of columns, and it takes *FOREVER* to set each column individually to text using the little import screen (can only select one column @ a time). Thanks, Mouse Tag: Password Protect Tag: 37764
  - 9
    - how do I delete? Hi, XL2K: How do I delete an add-in (*.xla file) from the Tools drop-down menu if it is already been removed from the "Add-in's available" list and from its default location?. TIA Martyn --- Outgoing mail is certified Virus Free. (Giden posta virüssüz olarak belgelendi.) Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.693 / Virus Database: 454 - Release Date: 31.05.2004 Tag: Password Protect Tag: 37760
  - 10
    - is there a way? To access my VBA project codes again of which its password I've forgotten? TIA --- Outgoing mail is certified Virus Free. (Giden posta virüssüz olarak belgelendi.) Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.693 / Virus Database: 454 - Release Date: 31.05.2004 Tag: Password Protect Tag: 37754
  - 11
    - Opening Documents Hi All, I have a problem which is driving me mad. I have tried looking on Microsoft website, but as always, can find no real help. When I open a spreadsheet from my desktop, Excel puts a 1 after the file name, and will only let me save it as a New File. If I open the same file from within Excel, then there are no problems. Any clues?? Cheers Norm Tag: Password Protect Tag: 37752
  - 12
    - Excel & Email I was wondering if there was a way to setup an Excel spreadsheet that has a bunch of email addresses in it, to send an email (through Outlook) to everyone in the spreadsheet? (Pushing a button, or running a macro or something?) Thanks! Eric Tag: Password Protect Tag: 37751
  - 13
    - Missing KB's Hi I am looking for KB291070, KB214032, KB113600. I can find KB291070 in Japanese, but the 2 others are gone. I can find plenty documents which links to them and a month ago KB291070 was also there. All KB's concerns Excels inability to save to drives where you don't have delete permissions. Is this an attempted cover up, or do I need a reintroduction course to google? Best regards Flemming J P Tag: Password Protect Tag: 37749
  - 14
    - Conditional formating an entire row? Hi there I am looking to shade an entire row within a worksheet based upon the value in the first column. The first column contains days of the week, I want to shade the rows for all Mondays, I can shade the first box (Monday ) using conditional formatting, but I can not think how to shade the rest of the row. Is this possible? Thanks Chris Ps I'm still using MS office 97 Tag: Password Protect Tag: 37741
  - 15
    - Watermark Image on Sheet Is it possible to place a 'Watermark' image on a worksheet i.e. Company logo as you can do in Word? Thanks Tag: Password Protect Tag: 37735
  - 16
    - Web page with Excel When I create a Web page from a Excel doc the lines of the columns and rows do not appear, can anybody please help. John Tag: Password Protect Tag: 37733
  - 17
    - Row amd column heading I have received one excel file in which rows number (1,2...) and column name (A,B,...) are in some big font 18, or maybe more. I couldn't find option to make them standard. Thanks in advance, Emilija Tag: Password Protect Tag: 37731
  - 18
    - Automatic Capital letter entry Is it possible to format a cell so that each time a lower case letter i typed into that cell a upper case letter will appear in a cell Example, entering Canadian postal codes, type in v2e 1m1 and have i change to V2E 1M1 automatically. I would perfer not to use macros as have never used them before -- Message posted from http://www.ExcelForum.com Tag: Password Protect Tag: 37727
  - 19
    - Running macros for different cells at the same time Hi all, Is it possible to run different macros on different cells at the sam time? If so how do I go about setting it up? Cheers Michae -- Message posted from http://www.ExcelForum.com Tag: Password Protect Tag: 37726
  - 20
    - Can this VBA for work on text files be modified for a different job ? I have been using the code below (which, from memory, came from the M-Soft site before I hashed it about) successfully to open 2 text files, appending the whole of one file to the end of the other, then deleting the source file. Now a new task is to; - update all text files in a specified folder by appending a new record. This is to be a daily routine, and there should end up being about 800 to 1000 text files to be updated. - The information for the record that is appended to each file comes from a single text file each day (source file). - The first column of this 'source file' holds a 3 character stock symbol. This symbol needs to be used to find the right destination file which is named the same as the 3 charaters & "tv.txt". - The source file is named with a date "yymmdd" & ".txt". This provides the first column of the record being appended to the found 'destination file'. The second, and last, column of the new record comes from a looking up of the value next to the associated symbol in the source file. - Not any of these files should be "Killed" as per the ccode below. Preventative measures; - the delimiting is different between the files. 'Comma' in the source file, and 'space' in the destination. - If a destination file is not found then it could be created. - If there is no record in the source file for an existing destination file then the date recorded should be made with an associated 0 value in the second column. Here's a sample of a 'Source File' named < 040531.txt > ; NAB,1728 WBC,1087 AMP,892 AWE,675 TAH,546 SUN,430 FGL,418 MAP,311 BOQ,311 ACU,307 BLD,303 Here's a sample of 'Destination File' named < ACUtv.txt > ; 040521 243 040524 120 040525 162 040526 449 040527 114 040528 167 -so the next appended record for ACUtv.txt should be; 040531 307 Here's the code I have been using to append the whole of one text file to the end of another, which I'm hoping can be modified for above, and would dearly appreciate some pointers for adapting. Sub AppendFiles1() Dim DayName As Variant Dim soName As Variant Dim goodgoing As Boolean Dim SourceNum As Integer Dim DestNum As Integer Dim Temp As String Dim Message, Title, Default On Error GoTo ErrHandler goodgoing = True ' This block - request file name to append to Message = "Enter a File Name to append to (not inc .ext)" Title = "Append to this .d File Name" Default = Right(Range("M9").Value, 5) DayName = InputBox(Message, Title, Default) If Len(DayName) > 5 Then DestNum = FreeFile() Open "E:\MarketManager\ascii\" & DayName & ".d" For Append As DestNum Else MsgBox "You didn't enter a filename" goodgoing = False End If ' Open the source text file. soName = Range("M9").Value SourceNum = FreeFile() Open "E:\MarketManager\ascii\" & soName & ".so" For Input As SourceNum ' Read each line of the source file and append it to the destination file. Do While Not EOF(SourceNum) Line Input #SourceNum, Temp Print #DestNum, Temp Loop CloseFiles: ' Close the destination file and the source file. Close #DestNum Close #SourceNum On Error Resume Next If goodgoing = True Then Kill "E:\MarketManager\ascii\" & soName & ".so" End If On Error GoTo 0 Exit Sub ErrHandler: MsgBox "Error # " & Err & ": " & Error(Err) Resume CloseFiles End Sub ' <<<<<<<<<>>>>>>>> Thanks Jon Tag: Password Protect Tag: 37725
  - 21
    - Open Password PRotect Excel file from ASP I am doing my MCA project from Chennai . I need to import data fro excel to Oracle . But the source excel files are workbook and workshee protected . I am not able to open the files even if I try to unprotec them . Can u please find out the way or a solution ? my email id i hsinha80@rediffmail.co -- Message posted from http://www.ExcelForum.com Tag: Password Protect Tag: 37718
  - 22
    - Relative formatting I created an excel file which extracts information from several workbooks. In one column, the addressing is relative (i.e.: ='[file_name1.xls]Spreadsheet_name'!$B$25), while in other columns the address is absolute (i.e.: ='C:\Documents and Settings\SaarB\My Documents\[file_name1.xls]Spreadsheet_name'!$B$25). How can I turn all addresses to relative format? This is essential so that when copying the files to another computer, the file identifies all other excel files which it is linked to. Any help would be most appreciated. Saar Tag: Password Protect Tag: 37717
  - 23
    - excel-access combination hi i've a database in excel. I need to print a specific Report in MS-Access using a particular record in ms-excel. OR I've 2 worksheets. worksheet 1 contains - 500 records worksheet 2 contains a format that is to be printed (as ONE RECORD per page). How can it be possible, if i enter the 501th record and get the print of the same from worksheet 2. How can i do it. please suggest.. Tag: Password Protect Tag: 37713
  - 24
    - labels assoc. w/specific data point I would like to carry a label with a specific data point on a lin graph. I keep track of my blood pressure on a spreadsheet. I use a lin chart. I keep notes next to the data column of things that affect i such as starting/stopping a medication or stressful circumstances an show it to my doctor. It would help if I could show those note somehow on the graph. I know I can insert a text label on the chart much like a title. Bu that doesn't work very well because when I add more data on the sam page, the graph shifts so the label isn't associated with the same dat point anymore. I have about 4 years worth of daily data for this. Currently I handwrite the notes on the graph which is tedious and no very accurate. Idea to solve this: (1) Is there a way to put have a label that ca be carried next to the data point on the line? (2) Is there a way t put in a second label on the x-axis along with the date? (3) Can create a 2nd x-axis that runs on the top of the graph with differen labels? (4) Is there a way to plot a column with text in it? I have excel 97. The x-axis is set as column A (date) and data point in columns B & C. The data is a single number in mmHg for bloo pressure. Col D is a notes column that isn't in the graph. I hav created 4 charts, each covering different lengths of time, whole 4 yrs whole 4 yrs broken into two pages, last 6 months, last 3 months. Thanks for your help! :-) coolchinchill -- Message posted from http://www.ExcelForum.com Tag: Password Protect Tag: 37711
  - 25
    - Row difference What use of "Row Difference" & "Column Differences" command mentioned in GO TO Menu. S. karan --- Message posted from http://www.ExcelForum.com/ Tag: Password Protect Tag: 37704

I'm sure there is a simple process for this but..

I want to Password Protect an Excel file so that the user is unable t
see any data until the correct password has been entered. I do not wan
the user to have a Read-Only option either.

Any suggestions?

Thanks
And

--
Message posted from http://www.ExcelForum.com

Top

Re: Password Protect by a_ndy2003_uk

a_ndy2003_uk
Thu Jun 03 05:29:53 CDT 2004

All you need to do when protecting an Excel file is:

1. File
2. Save As
3. Tools (Top right hand corner)
4. General Options
5. File Sharing >> Passwor

--
Message posted from http://www.ExcelForum.com

Top