LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 64
Default Hyperlink to exit Excel

works fine once I change "Sheet2!A1" to exit the name of the hyperlink

THANK YOU

"Gary''s Student" wrote:

Click on cell A1 in Sheet2 and:

Insert Hyperlink to a place in this document

This will create a hyperlink to itself. Then in the worksheet code area,
insert the following:

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
If Target.Parent = "Sheet2!A1" Then
Application.Quit
End If
End Sub

--
Gary''s Student - gsnu200781


"Pimamedic" wrote:

Is there a way in Excel 2002 to make a link so that one click will close the
program, take me to the exit routine?

Thank you

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Excel 07 won't exit Elle Setting up and Configuration of Excel 0 July 27th 07 12:40 AM
macro wants to exit excel curlydave Excel Discussion (Misc queries) 3 July 2nd 06 04:19 PM
Excel - Prompt to save on exit. Fenris Excel Discussion (Misc queries) 0 November 21st 05 05:11 PM
Excel 2003 Will Not Save On Exit tmyhlfgr Excel Discussion (Misc queries) 2 November 3rd 05 02:45 PM
exit excel welshwizzard Excel Discussion (Misc queries) 1 January 18th 05 12:02 AM


All times are GMT +1. The time now is 03:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"