thekneeguy
10-15-2005, 07:11 PM
Hello all....
I have a workbook that opens to a navigational sort of sheet. Then the user selects a command button with an assigned macro to go to the main sheet.
The macro is essentially
sheet("products").activate
sheet("products").visible = true
range("b13").activate
so that when the sheet opens it automatically goes to the first appropriate row of the sheet. This row then has two columns for items and cost. The next column the user enters the number of those items they select and a hidden column multiplies the number items by the cost and deducts it from a "beginning budget" cell which shows a running sum of remaining budget.
My problem is this...for some reason the first row will NOT retain the formulas. When I unhide the columns and replace the formula in the first row it does not stay when the sheet is activated which leads me to think maybe there is something wrong with the code to activate the sheet?
If so, is there a different way you would suggest coding this or a workaround of some sort?
The sheet is made to autopopulate the first column of the first available row no matter where the cursor is the only reason i activated a cell was that the picture elements at the top of the page were always highlighted when the sheet opened and i wanted to get away from that. But I still don't understand why the row won't retain the formula. Any ideas anyone?
Thank you
I have a workbook that opens to a navigational sort of sheet. Then the user selects a command button with an assigned macro to go to the main sheet.
The macro is essentially
sheet("products").activate
sheet("products").visible = true
range("b13").activate
so that when the sheet opens it automatically goes to the first appropriate row of the sheet. This row then has two columns for items and cost. The next column the user enters the number of those items they select and a hidden column multiplies the number items by the cost and deducts it from a "beginning budget" cell which shows a running sum of remaining budget.
My problem is this...for some reason the first row will NOT retain the formulas. When I unhide the columns and replace the formula in the first row it does not stay when the sheet is activated which leads me to think maybe there is something wrong with the code to activate the sheet?
If so, is there a different way you would suggest coding this or a workaround of some sort?
The sheet is made to autopopulate the first column of the first available row no matter where the cursor is the only reason i activated a cell was that the picture elements at the top of the page were always highlighted when the sheet opened and i wanted to get away from that. But I still don't understand why the row won't retain the formula. Any ideas anyone?
Thank you