-
Open Workbook at Specific Sheet
Hi
Excel 2000 Win7
On this page on forum
http://www.vbaexpress.com/kb/getarticle.php?kb_id=338
It advises how to open wb at spec;if sheet. It works great on sample file.
Hoever I cannot get it to work on my wb. Have followed the instructions and the only two things I am not sure on are:
Instructions: Not sure what Project Explorer is ? nothing by that name on my Excel VBE.
On the sample file the selection box across the top says 'Workbook' whereas on mine vbe it says 'General'
Any comments appreciated.
Regards
Charlie Harris
-
Normally your screen is divided in two (or three) areas. Left side/right side/bottom.
- When you push alt+F11 you are in the vbe editor
- When you push ctrl+r that's the project explorer
In excel you have on the left side some kind of map : excel objects
- click on the + then you'll see sheet1, sheet2 ...
- you have to double click on thisworkbook
In right side, the general will become workbook and you have two comboboxes on top of that screen. right combobox is the one where you choose the open area for a workbook = the things a workbook will do when you open it (if macros are enabled).
Charlize
-
Using XL2010 but I think the VBE interface is very similar, instruction 3 says:"In the VBE window, select Tools/Project Explorer " but I think it's: "In the VBE window, select View/Project Explorer".
(Ctrl+r does the same)
Also instruction 4.:"Select the ThisWorkbook module", selecting is not enough, you should double-click it.
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
-
Hi Charlize and p45cal
Thanks for your input. I will follow your instructions over the weekend, and let you know.
It does appear that I have been in the wrong place!
Have3 a good weekend
Thanks
Charlie
-
Hi Charlize and p45cal
Have installed as per your instructions and it works a treat !! I am very pleased with it. What a difference one more click makes !
Thanks and regards
Charlie
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules