sswcharlie
05-19-2011, 09:28 PM
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
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