Excel - Worksheet: Grouping multiple sheets

Scripting Forums AppleScript | Mac OS X
,
#1

Hey all I would like to group “Sheet1” and “Sheet2” in excel.

You can do this by holding apple key or the shift key and selecting the multiple worksheets. Was trying to create a group since that’s what excel finds this. If you control click on the grouped worksheets.

any help would be greatly appreciated.

thanks.

#2

Code works that works so far


tell application "Microsoft Excel"
	activate object sheet 2
end tell
-- selects sheet 2

How do you select another sheet without deselecting sheet 2

#3

Thanks but i get the following error with this code

"AppleScript Error

Microsoft Excel got an error: sheet {“Sheet1”, “Sheet2”} doesn’t understand the select message."


tell application "Microsoft Excel"
	--select sheet {1, 2}
	select sheet {"Sheet1", "Sheet2"}
end tell

– version: excel 2004 w lastest patches