MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by stephen Allenberg on January 14, 2002 6:24 PM

Pleas could someone explain to me how to insert this macro into
a worksheet

Lets keep the info in cell Y1 & Z1 Modify as needed

Posted by Bariloche on January 14, 2002 6:50 PM


Copy the subroutine, press Alt-F11 and the VB Editor will open. On the left-hand side there should be a Project Explorer window (if not go to View and select the Project Explorer). Double click the "ThisWorkbook" object for your workbook. A code sheet will pop up. Paste the sub in there and you're in business. Each sheet has its own code sheet as does the workbook. These are in addition to the code module sheets. Your sub is Workbook event procedure and as such it needs to be in the "ThisWorkbook" object to work.