Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlinks on Protected Sheets
Hi,
I have a protected sheet with some hyperlinks on it. However I am unable to click on any of the hyperlinks. The only protection option with anything to do with hyperlinks is the Allow Insert Hyperlinks option, which has no effect. My goal is to have a protected sheet with formulas hidden, yet the user can click on hyperlinks. BTW the Hyperlinks are inserted as worksheet formulas if that matters... Thanks Richard |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlinks on Protected Sheets
when protecting the sheet: turn ON : allow users to select locked cells allow users to select unlocked cells then it works for me in xlXP and xl2003 in xl97 i also didnt have any problems. cell:locked ON /hidden ON formula =hyperlink("http://microsoft.com") -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam Rich wrote : Hi, I have a protected sheet with some hyperlinks on it. However I am unable to click on any of the hyperlinks. The only protection option with anything to do with hyperlinks is the Allow Insert Hyperlinks option, which has no effect. My goal is to have a protected sheet with formulas hidden, yet the user can click on hyperlinks. BTW the Hyperlinks are inserted as worksheet formulas if that matters... Thanks Richard |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlinks on Protected Sheets
Thanks for the tip.
Works for me. I was hoping to be able to hide the cursor, the sheet is a kind of dashboard, but being able to click links is more important! "keepITcool" wrote in message .com... when protecting the sheet: turn ON : allow users to select locked cells allow users to select unlocked cells then it works for me in xlXP and xl2003 in xl97 i also didnt have any problems. cell:locked ON /hidden ON formula =hyperlink("http://microsoft.com") -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam Rich wrote : Hi, I have a protected sheet with some hyperlinks on it. However I am unable to click on any of the hyperlinks. The only protection option with anything to do with hyperlinks is the Allow Insert Hyperlinks option, which has no effect. My goal is to have a protected sheet with formulas hidden, yet the user can click on hyperlinks. BTW the Hyperlinks are inserted as worksheet formulas if that matters... Thanks Richard |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlinks on Protected Sheets
hmm... Let's get creative! since a dashboard should fit on 1 screen, there should be no need to scroll... and IF you dont want to see that graveyard box... try following (quick test, seems to work) in thisworkbook Private Sub Workbook_Open() Sheet1.ScrollArea = "A1:H24" Sheet2.Activate Sheet1.Activate End Sub in sheet1 code module Private Sub Worksheet_Activate() Worksheet_SelectionChange ([a1]) End Sub Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(Target, Range(Me.ScrollArea)) Is Nothing Then Me.Cells(1, 256).Activate End If End Sub -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam Rich wrote : Thanks for the tip. Works for me. I was hoping to be able to hide the cursor, the sheet is a kind of dashboard, but being able to click links is more important! "keepITcool" wrote in message .com... when protecting the sheet: turn ON : allow users to select locked cells allow users to select unlocked cells then it works for me in xlXP and xl2003 in xl97 i also didnt have any problems. cell:locked ON /hidden ON formula =hyperlink("http://microsoft.com") -- keepITcool www.XLsupport.com | keepITcool chello nl | amsterdam Rich wrote : Hi, I have a protected sheet with some hyperlinks on it. However I am unable to click on any of the hyperlinks. The only protection option with anything to do with hyperlinks is the Allow Insert Hyperlinks option, which has no effect. My goal is to have a protected sheet with formulas hidden, yet the user can click on hyperlinks. BTW the Hyperlinks are inserted as worksheet formulas if that matters... Thanks Richard |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlinks on Protected Sheets
Thans for the tip, but I should have made my requirements fully known!!!
The sheet is in a "data file" and I don't want it to have any VBA code, so people don;t have to get the warning every time if they choose not to trust me. All code will be in the add-in that will be signed and approved once only. I therefore assume that I cannot handle events on that sheet. Thanks for the tip anyway. Rich "keepITcool" wrote in message .com... hmm... Let's get creative! since a dashboard should fit on 1 screen, there should be no need to scroll... and IF you dont want to see that graveyard box... try following (quick test, seems to work) in thisworkbook Private Sub Workbook_Open() Sheet1.ScrollArea = "A1:H24" Sheet2.Activate Sheet1.Activate End Sub in sheet1 code module Private Sub Worksheet_Activate() Worksheet_SelectionChange ([a1]) End Sub Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(Target, Range(Me.ScrollArea)) Is Nothing Then Me.Cells(1, 256).Activate End If End Sub -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam Rich wrote : Thanks for the tip. Works for me. I was hoping to be able to hide the cursor, the sheet is a kind of dashboard, but being able to click links is more important! "keepITcool" wrote in message .com... when protecting the sheet: turn ON : allow users to select locked cells allow users to select unlocked cells then it works for me in xlXP and xl2003 in xl97 i also didnt have any problems. cell:locked ON /hidden ON formula =hyperlink("http://microsoft.com") -- keepITcool www.XLsupport.com | keepITcool chello nl | amsterdam Rich wrote : Hi, I have a protected sheet with some hyperlinks on it. However I am unable to click on any of the hyperlinks. The only protection option with anything to do with hyperlinks is the Allow Insert Hyperlinks option, which has no effect. My goal is to have a protected sheet with formulas hidden, yet the user can click on hyperlinks. BTW the Hyperlinks are inserted as worksheet formulas if that matters... Thanks Richard |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlinks on Protected Sheets
Rich wrote : I therefore assume that I cannot handle events on that sheet. I assumed... famous last words :) You can set up an application level event handler in the addin.. in thisworkbook of the addin... Option Explicit Dim WithEvents appXL As Application Private Sub appXL_SheetChange(ByVal Sh As Object, ByVal Target As Range) Debug.Print Target.Address(external:=True) End Sub Private Sub Workbook_BeforeClose(Cancel As Boolean) Set appXL = Nothing End Sub Private Sub Workbook_Open() Set appXL = Application End Sub now you'll see the address of ANY cell that is changed... see the dropdowns in the codepane... select appXL on the left.. check the available events on the right. -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlinks on Protected worksheet | Excel Discussion (Misc queries) | |||
HYPERLINKS IN A PROTECTED SHEET | Excel Discussion (Misc queries) | |||
Protected Hyperlinks | Excel Discussion (Misc queries) | |||
Hyperlinks and protected workbooks | Excel Worksheet Functions | |||
using hyperlinks in a protected worksheet | Excel Programming |