I have set the default in Excel to move across to the next cell after I press Enter. This is fine for most workbooks but I have a particular workbook in which it would be preferable (save keystrokes) for the cursor to move down one cell. Is it possible to have one action as the default but another for a particular workbook?
You can insert this in the workbook open event:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Although I have been using Excel for 20 years and Excel 2007 for 6, I have no idea how to access the workbook open event. What do I do?
Hi Cullism,
Use this event code in the "ThisWorkbook" module:
Directions for running the routine(s) just suppliedPlease Login or Register to view this content.
Copy the code to the clipboard
Press ALT + F11 to open the Visual Basic Editor.
Save your Workbook As Macro-Enabled
Click on "ThisWorkbook"
Type "Option Explicit" then paste the code under it
And, you should be ready to go
Thanks a lot for your help. It wasn't easy as your routine didn't work straight away. I entered the routine in each month, saved it, but then found that it didn't make any difference. After I had applied the routine to all 12 months without apparent success I re-opened each month and found that it was, in fct, working.
Many thanks.
Did you put it in the "ThisWorkbook" module? If you did then it should have worked for all the sheets in that book
My last reply wasn't very clear. I have 12 separate workbooks, each with 2 worksheets. Your advice worked on all 12 (after a bit of hesitation).
Thanks again.
Communication is so "iffy" sometimes - glad it's working! And - you're welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks