Posted to microsoft.public.excel.misc

Colin Hayes Colin Hayes is offline

external usenet poster

Posts: 465

Workbook_Open code help

HI

I'm trying to put code in the open workbook area so that sheet1 and
sheet2 both open with the cursor on A200.

I'm getting errors with this code :

Sheets("Sheet1").Range("A200").Select
Sheets("Sheet2").Range("A200").Select

Can anybody advise how to do this?

Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
Private Sub Workbook_Open() doesn't run	Steve Starr	Excel Discussion (Misc queries)	4	April 3rd 11 05:05 AM
About workbook_Open madro	Miguel Angel	Excel Worksheet Functions	0	November 2nd 06 12:00 PM
Problem with Workbook_open	Vick	Excel Discussion (Misc queries)	13	February 14th 06 10:40 PM
Deleting Workbook_Open code	Paige	Excel Discussion (Misc queries)	3	January 31st 06 07:39 PM
Workbook_Open ()	Bill Martin	Excel Discussion (Misc queries)	12	December 20th 05 05:37 PM

All times are GMT +1. The time now is 11:25 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us