Addition and scrolling

[psyfect]

Hello!

In the past I have used a sheet that allows you to add data to a cell in the following manner (assuming the cell contains the number 5):
I could highlight the cell; press +5 and it would then display 10 while the formula bar would show something like =5+5.

1) I'm trying to do this now and it keeps replacing data instead of adding to it. How would I fix this?

2) Another, less important, question I have is; is it's possible to auto scroll to a column when you open a file (i.e. it's the 12th, so it scrolls to the 12th row)?

Thanks!

Edit: On a side note; I saw someone ask about inserting pictures. I have a graph I tried to "send to back" so it sits behind the data input cells.
3) It didn't work, so I guessed it wasn't possible; is that right?

[mudraker]

Answer to Question2

You can with an Open Workbook Macro

Thse instructions are worded in case you know nothing about macros

Press Alt + F11 - Takes you to the VB Editor program

On the left hand side Just under the Tool bar you should see a window tiled Project - VBAProject. If you do not see it Press Ctrl + R

In this window select the entry for ThisWorkbook

Past the following code into the big Righthand window which

Private Sub Workbook_Open()
ThisWorkbook.Sheets(1).Cells(Day(Now()), "a").Select
End Sub

I can not answer your other 2 questions

[psyfect]

Works really well, thanks!
1a) Is there a way to make it signed so I can still keep my security level high?
1b) Where can I get a list of excel vb commands (I know vb really well) so if I want to change it to select a range of cells?