Date: Mon, 07 Oct 2002 23:23:46 -0500 (Central Daylight Time) From: Mark Jacobson To: 810-022-01@uni.edu Subject: MASI question (fwd) Hi 022 students, Problem with the Macro question answered here. Second time I saw this problem today (Monday, October 7th). Reminder: Quiz on Wednesday. Mark ---------- Forwarded message ---------- Date: Mon, 07 Oct 2002 22:30:01 -0500 (CDT) From: MARK JACOBSON To: Logan.Tom@stanford.edu Cc: jacobson@cns.uni.edu Subject: Re: MASI question Logan, Yes, I just downloaded your Excel workbook, after I saw it was attached. Indeed, you forgot to name your Sheet1 worksheet Metals. ---- Double click on the Sheet1 tab, and then you can rename that sheet to be Metals instead of Sheet1. Or you can right-mouse-button-click on the Sheet1 tab, and the popup menu will give a choice of Rename, is the other way to do it. Finally, Alt key, followed by O, followed by H, followed by R is the keystroke way to get to Rename the Sheet1 or whatever sheet. Format menu, Sheet command, Rename subcommand... - - - Alt key O H R Alt, O, H, R --- - - - Private Sub Workbook_Open() Sheets("Metals").Protect UserInterfaceOnly:=True ------ End Sub Metals does NOT exist, is why you get the strange error message when the Workbook_Open() event code gets executed. Sheets() is a collection, and the name "Metals" is a subscript to specify one worksheet from the entire collection of worksheets in the Workbook. Thus the error subscript out of range sort of makes sense. Now you know something else new about Excel! Good luck, Mark P.S. You played awesome against USC on Sunday, and I expect the next time Stanford volleyball faces USC, the outcome might be a different story. Hopefully, you will get to meet UNI again in the NCAA tournament in December in the elite eight or higher level! Our 4th and 5th home games here are Friday and Saturday. The 1st and 3rd home games sold out, so hopefully, anyone who wants to go will reserve a ticket in advance by Thursday for either or both West Gym games.