About Us

Excel 2002.

I can use Excel 2000 if that helps

"Don Guillett" wrote:

What version of excel are you using?

--
Don Guillett
SalesAid Software

"Bill Healy" wrote in message
...
Don thank you for your prompt response!

It's a shame that I don't follow it!!

Sheet tab - which one?
Do I enter your macro as "MS 4.0 Marco or 5.0 dialogue"?

Sorry if I'm being dense....

"Don Guillett" wrote:

Here is one I use to goto the sheet from a printed name in a cell. Right
click sheet tabinsert thissave. Double click on the cell with the name
in
it. ie: mysheet1

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
Application.DisplayAlerts = False
Dim WantedSheet As String
WantedSheet = Trim(ActiveCell.Value)
If WantedSheet = "" Then Exit Sub
On Error Resume Next
If Sheets(ActiveCell.Value) Is Nothing Then
' GetWorkbook ' calls another macro to do that
Else
Sheets(ActiveCell.Value).Select
ActiveSheet.Range("a4").Select
End If
Application.DisplayAlerts = True
End Sub

--
Don Guillett
SalesAid Software

"Bill Healy" wrote in message
...
Any easy way to search for a specific sheet?

i.e. Like CTRL F, however I'm looking to find a specific worksheet
rather
than scroll across until I find it.

Issue it that I have 80-90 worksheets (names like "John Smith, Fred
Jones"
instead of "Sheet 1,2, etc)

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Print all charts in a workbook (multiple worksheets)	aewsaws	Charts and Charting in Excel	4	May 12th 23 03:45 AM
Count the number of worksheets in a workbook	Vincdc	Excel Discussion (Misc queries)	7	January 17th 05 11:57 PM
How to print multiple worksheets in one workbook on the same page.	rrdiorio	Excel Discussion (Misc queries)	2	January 6th 05 11:40 PM
"countif" from multiple worksheets within workbook		Excel Discussion (Misc queries)	2	December 10th 04 06:59 PM
Removing links to other worksheets from within a workbook	rjb	Excel Discussion (Misc queries)	2	December 9th 04 08:04 AM

Menu

About Us