Hi all. Newbie here... long time Excel user.
I am having a difficult time figuring out how to make it so that each worksheet in my workbooks opens to show the same group of data that every other worksheet shows. Naturally, I'm talking about something like AB179:AS250, not A1:J38. =)
I can click the box in each worksheet and then arrow up or down to get that box to present itself, but I'm hoping for a much simpler solution. Thank you kindly for any help.
--Greg
This event code in the ThisWorkbook module works (you'll want to play with the Zoom
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
Not sure what that is... a macro?
Directions for running the routine(s) just supplied
If you haven't used macros before you'll need to go to:
File- options - trust center -trust center settings - macro settings ,
the second option down (disable all macros with notification)
Then - Copy the code to the clipboard
Open your Workbook
Press ALT + F11 to open the Visual Basic Editor.
In this case you'll select the ThisWorkbook module by clicking on it
(not from the insert menu)
Type "Option Explicit" then paste the code under it
And that's it!
*Be sure to save the book with the code as Macro-Enabled
Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks