Posted to microsoft.public.excel.programming

MakeLei

external usenet poster

Posts: 47

Sheet codename not working

Hi,
XP and Excel2003.

What might be the reason why this is not working (Sheet2 is codename):
Sheet2.Select

I have tried all possibilities that I can imaging, but no. I have another
file and selecting sheet with code name (Sheet4.Select) funtions just fine.

Now using code:
Workbooks.Open Filename:=Doc2
ActiveWorkbook.Sheet2.Select

Opens Doc2 excel file just fine, but does not open the sheet.

Thanks in advance
MakeLei

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Selecting Sheet By Codename	Kris_Wright_77	Excel Programming	4	December 16th 09 04:23 PM
Hide sheet via codename	[email protected]	Excel Programming	3	September 13th 06 08:28 PM
change sheet codename	Gary Keramidas	Excel Programming	4	March 5th 06 12:54 AM
Selecting a sheet by codename	Dr.Schwartz	Excel Programming	3	September 3rd 04 02:15 PM
Using sheet codename problems	Dustin Carter	Excel Programming	1	February 20th 04 10:26 PM

All times are GMT +1. The time now is 08:50 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us