make excel start in particular cell

**fermerboy** · 12-01-2006, 12:59 PM

Hi, I have searched the site/forum and haven't managed to find an answer.

Is it possible to get excel to start a spreadsheet in a particular cell?
I have a workbook with a number of sheets, and I would like it to start on A1 in the first sheet everytime the file is used.This sheet has the instuctions on it for using the workbook.
I can't find an option to do this anywhere, so do I need a macro??
Bit of a beginner on the macro side.
I'm using excel 97 if that makes any difference.
Any help appreciated.
Thanks
FB

**Mallycat** · 12-01-2006, 03:19 PM

Yes you need a macro, a simple one though

sub auto_open()
sheets("sheet1").select
range("A1").select
end sub

Open VBA Alt F11

In the top left hand window, find the name of your workbook, select it, then select Insert\Module.

Paste the above code in the right hand window of your new module. Save it, and that's it. Make sure you change the name of the sheet above to the one you want.

Matt

**fermerboy** · 12-01-2006, 04:24 PM

Thank you Mallycat.
That does exactly what I want.
Need to get into this macro stuff I think.
Thanks.
Fermerboy

**dacius1** · 12-01-2006, 04:58 PM

fermer - That did not work. Mcat's solution should work. Just remember to change "sheet 1" to what ever the desired sheet is named.

I also have the need and that macro works pretty good.

make excel start in particular cell

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

make excel start in particular cell

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions