LinkBack URL
About LinkBacks
I am having a problem with the 2003 Excel workbooks that I convert to 2010. They do not open at the last saved change location. I am trying to make all sheets in each workbook open at cell A1. Is there an option that I am missing?
I am having a problem with the 2003 Excel workbooks that I convert to 2010. They do not open at the last saved change location. I am trying to make all sheets in each workbook open at cell A1. Is there an option that I am missing?
Put this in the Workbook module:
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
That worked but I have the top 4 rows frozen. Is there a way to display all rows in order?
Well - if you've gotten the freeze panes feature incorporated into the sheets at the same row - you could select the first row that would "fold under"
- or do you mean something else??Please Login or Register to view this content.
Thanks! That worked great.
You're welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks