Hyperlink Not Working If Sheet Protected

Jun 1, 2009

I have a excel worksheet with hyperlink. If the sheet is protected I am unable to use the hyperlink even though I have unblocked the protected cells.

View 9 Replies


ADVERTISEMENT

Allow Hyperlink Clicks On Protected Sheet

Jan 21, 2008

Does anyone know if/ how i might unlock hyperlinks on my protected spreadsheet without having to unlock the cells they are placed in?

View 3 Replies View Related

Macro Not Working When Sheet Protected?

Sep 19, 2013

I have certain cells which I want the formulas hidden to the end user and protected so they can't update them.

I've locked and hidden these cells and protected the sheet however my Macro's fail to work thereafter.

Protect the sheet for the user interface only. This has to be done in VBA:

- Activate the sheet.

- Activate the Visual Basic Editor (Alt+F11).

- Activate the Immediate window (Ctrl+G).

- Type

ActiveSheet.Unprotect

- Press Enter.
- Type

ActiveSheet.Protect UserInterfaceOnly:=True

- Press Enter.

The sheet is now protected for the end user, but VBA code can freely manipulate it.This works well however when I go to another page and do the same it stops working on the original sheet.I would like to know if there is an easy way to:

protect/unprotect all sheets in one go and have the macros still work?

When I protect pages individually I want the following to be allowed:

Select unlocked/locked cells
Format
Sort
Use autofilter
use pivottable

I will first save which cells are un/locked & hidden.

View 9 Replies View Related

Me.Rows.Autofit With A Protected Sheet Not Working.

Jul 23, 2009

Me.Rows.Autofit with a Protected Sheet not working.
Basically I want to use vb code which is

View 2 Replies View Related

AutoFilter And Sort Not Working On Protected Sheet

Dec 20, 2012

When I either manually check the box for allowing sorting and autofiltering, or I do it through vba with:

Code:

With Sheets("Inventory")
.Protect Password:="###", AllowSorting:=True, AllowFiltering:=True, AllowUserInterface:=True
.EnableAutoFilter = True
End With

I still am unable to use the icons. The icons are clickable to filter or sort, but every time they say that the cells I am selecting are protected. I want them to be protected from editing the data, but want to allow them to be sorted or filtered.

View 1 Replies View Related

Macros Not Working When Sheet Is Password Protected

Jan 9, 2007

I am trying to password protect some of the cells in a worksheet. However doing that starts giving errors with Macros. The Macros are no longer working and infact giving error. What can I do to stop that happening?

View 9 Replies View Related

Odd One, Up And Down Arrows Stop Working When Sheet Protected

Jan 10, 2008

The sheet was working fine, then all of a sudden (i dont know what i have done) the up and down arrows (on my kayboard) wont work when the sheet is protected, when i unprotect the sheet they work fine, i can use left and right. i have checked the scroll lock isnt pressed/illuminated on my keyboard.

View 9 Replies View Related

Dynamic Ranges (tables) Not Working On Protected Sheet?

Sep 10, 2013

I have a data set that is defined as a table (Ctrl + T). There are formulas so I locked those cells and Protected the sheet. If I am at the bottom right cell, and press Tab to add a new row, I get an error message: "Cannot use this table functionality on a protected sheet"

I really need to protect the cells with formulas so that the are not accidentally deleted. But I also want to retain the Table format.

Is there a way around this without using VBA?

View 1 Replies View Related

Protected Cells Jump To Hyperlink

Aug 23, 2006

I have a protected worksheet with about a dozen unprotected cells (so the user can just answer question from a validated list). Also unprotected is a hyperlink back to the main menu (Sheet1).

My problem is when a user clicks outside of where they should (i.e. on a protected cell) - it executes the hyperlink back to Sheet1.

I have tried unprotecting cells around the hyperlink. I even tried putting "dummy" hyperlinks around the main one referring it back to the same sheet.

View 7 Replies View Related

Excel 2007 :: Hyperlink Not Work With Cell Protected

Oct 24, 2012

Excel 07

I inserted a hyperlink into a cell that goes to a web page. It works when the sheet is NOT protected, as soon as I protect the sheet it stops working. How do can I lock the workbook and that cell so nobody can change it but the hyperlink still work?

View 2 Replies View Related

VBA Not Working On Another Worksheet When Protected

May 20, 2012

I have the following code which works fine when Sheet1 is unprotected (The code is placed in Sheet3)

however if I protect sheet1 then the code does not work

I have tried it with

Code:
ActiveSheet.Unprotect

Code:
ActiveSheet.Protect
it still will not work on Sheet1

here is the code

Private Sub Worksheet_Change(ByVal Target As Range)
Application.ScreenUpdating = False
On Error GoTo Handler
With Sheet1.Range("B6:B10045")

[Code] ....

View 2 Replies View Related

VBA Macro Not Working When Workbook Is Protected

Apr 23, 2008

I wish I could have been more specific with my Title. This is what I am encountering. I used the McGimpsey code for generating a unique sequential number every time a workbook opens. I tailored the code to fit my needs and stuck it into my invoice sheet. For the longest time I was unable to make it work until I moved the code from a template to a standard workbook. Then I was able to make it work as long as the sheet was unprotected. I realized that to get the code to work I had to then unprotect the cells that the code was writing to. Now that I've done that I am getting errors in the code that weren't there before, rendering the macro useless. The code I am using is:

View 14 Replies View Related

Arrow Keys Not Working On Protected Worksheet

May 4, 2008

Have a file that I have been coding and find when I open to a worksheet with limited access cells, the Up and Down arrows will not move vertically though Lrft and Right arrows OK though not raping arround. This problem may have been on for sometime and I haven't been back to it. Other Excel files all OK.

View 4 Replies View Related

Hyperlink Not Working

Feb 19, 2010

in my cell there is following formula/hyperlink:

=HYPERLINK(VLOOKUP($C6;Activities!$A:$AA;MATCH(D$5;Activities!$6:$6;0);FALSE);LEFT(VLOOKUP($C6;Activities!$A:$AA;MATCH(D $5;Activities!$6:$6;0);FALSE)

a) Clicking on it says "Cannot open the specified file."
b) I would like to define the format of hyperlinks to look different.

View 9 Replies View Related

2007 Hyperlink Not Working In 2010

May 15, 2013

I have a workbook that uses a index page that I created. It has lots of hyperlinks on it to route them to other sheets in the workbook. Each worksheet has a hyperlink to go back to the index page, and one to open an email. I have a user with 2010 now that is getting an error when clicking on the hyperlink. Error Message: "This Operation Has Been Canceled Due To Restrictions on the Computer. Contact Your Administrator."

View 3 Replies View Related

Macro To Create Hyperlink List Not Working?

Jul 10, 2014

I have a macro that would create a hyperlink for every one of the files in a folder that a specific cell gave the url address for.

Recently I got moved to a new pc and forgot to migrate my macro's over. In combing back through previous threads... I found the macro, but now it won't work.

[Code] ......

The error that I get is:

Compile error:
Invalid use of property

I get this error at row

Range (Cells(Rows.count, "U").End(xlUp).Offset(1, 0).Address)

Why did the macro used to work and not anymore?

View 6 Replies View Related

Excel 2010 :: Macro Runs On Protected Sheet But Changes Protect Sheet Options?

Feb 24, 2011

I am using Excel 2010 and I have a password protected workbook with password protected sheets that uses several macros. Most of them, in order to run, have to un-protect the sheet and then re-protect it again. This has been accomplished easily enough by adding ActiveSheet.Unprotect Password:= "mypassword" and ActiveSheet.Protect Password:= "mypassword" to the appropriate places in the script. All of my macros, which do various things like sorting and moving data, deleting blank rows, displaying dialog boxes containing warning messages etc. run fine.

My problem is this: when I password protect the sheets manually, I have checked the following options in the "Protect Sheet" dialog box. Under "Allow users of this worksheet to" I have checked 1)Select unlocked cells and 2)Format cells. After entering my password and closing the dialog box my sheet is protected, but I can edit cells in the manner my allowances permit. However, once I run any of the macros that un-protect and re-protect the sheet, I remain able to select and edit unlocked cells (practically, for my purposes, this means that I can input data which will appear in the default font size and color of the sheet) but I cannot format cells (which, practically, for my purposes would allow me to occasionally change the font color and size of the data). Naturally, after running a macro, the other cell-formatting options are unavailable to me as well. Is there any way to get my manual selections to remain in place after running a macro that functions as mine do? Or is there any way to make my manual selections the default settings for a protected sheet?

View 4 Replies View Related

Copy And Paste From One Sheet To Another On Protected Sheet?

Apr 29, 2014

I have spent ages creating a work diary and have protected the sheets using VBA however on finishing the sheet one important thing that needs to happen is the ability to copy and paste information from the boxes to another worksheet. i.e MONDAY - SUNDAY

View 1 Replies View Related

Password Protected Sheet :: How To Unprotect A Sheet?

Jan 18, 2008

Does anyone know if there is a way to unprotect a sheet. The person who created this spreadsheet no longer works for our company and although we can see the spreadsheet, the formulas are hidden so we can't figure out where the data is being pulled in from. Any ideas?

View 9 Replies View Related

Cant Use [alt] + Pg Up Or Pg Dn On Protected Sheet

Jun 11, 2008

is there a code to still allow me to move between sheet tabs by using [alt] pg up or [alt] pg dn on a protected sheet?

View 9 Replies View Related

If Sheet Protected Then...

Apr 26, 2007

What code would I use to test if the sheet is protected or not? In other words:

If Activesheet.Protection = True Then
MsgBox "You have no authority!!!"
Else
' Some code here
End If

View 5 Replies View Related

Searching A Protected Sheet

Feb 11, 2010

I have a workbook whose worksheets use protection (don't want my calculations stomped on).

When the Protection is on, the search function does not work. You call it up, write what you are looking for, it accepts it, and then when you tell it to search it ignores you.

When you turn the protection off, the search function works just fine.

HOWEVER....Other workbooks I have with protection on its sheets do not share this problem, just this one workbook. And the problem is on all sheets in this workbook. The problem is not on any of the sheets in the other workbooks. I can't see anything different between them, but then I may not know what to look at.

View 2 Replies View Related

Allow Insertion Of Row In Protected Sheet

Sep 4, 2013

I wanted to know:

Q1. How can we insert new rows in a protected sheet?

For example: In the attached sample protected excel sheet "insert rows.xlsx" , if for Employee ID and Name fields, the user has more no. of records than provided, how can he insert new rows considering the fact that Company ID and Name field are locked.

Or any way to address this issue via some other method like adding a scrollbar,etc.

View 5 Replies View Related

Protected Sheet & Allow Use Of Autofilter

Dec 20, 2007

I've locked certain columns on my worksheet so that users cannot overtype target dates etc. I've password protected the worksheet.

The password protection means that for some reason the users can't use the autofilters that are on the header row.

Can someone help me solve this problem; I still need the locked cells and password protection on the sheet but the success of the sheet depends on users being able to filter for specific rows using the autofilter....

View 9 Replies View Related

Protected Sheet Will Not Allow Macro To Run

Mar 27, 2009

I have protected several sheets in my workbook to protect the forumlas and data for being tempered with by the users.

When I try to run my macro, I get an error message stating:

Runtime '1004'
You can not use this command on a protected sheet

And the debug is pointing to this part of my code

View 14 Replies View Related

Autofiltering A Protected Sheet

Dec 11, 2006

When I protect my sheet and have the option to allow the users to autofilter the sheet, how come it doesn't work? I want to allow people to autofilter the data in the worksheet but not modify the contents of the cell.

View 9 Replies View Related

Use Dropbox When Sheet Is Protected

Jan 26, 2009

I have a dropbox located on a sheet which other information needs to remain protected.

How do we give access to users to the dropbox while the remainder of the sheet is protected?

View 9 Replies View Related

AllowFiltering In Protected Sheet

Nov 10, 2009

I have a question relating to the use of autofilter in a protected sheet.

My code is working fine in setting the autofilter and locking down the sheet but a user then loses the ability to use the (Data - Filter - Show All) menu button.

Is there a way to have the worksheet protected, allow the use of the auto filters, and allow the use of the show all button?

Code below incase it is of relevence ...

View 9 Replies View Related

Copy Down Last Row On Protected Sheet

Jul 31, 2008

I am looking for VBA code that will unprotect the Workbook, prompt the user for the number of rows to be added, find the last row in the Worksheet, insert the requested number and reprotect the Worksheet. I would like the location where the rows are inserted to NOT be dependent on the "active" cell.

View 6 Replies View Related

Hyperlink Function: Links To A1 Of Sheet 1 To A1 Of Sheet 2

Nov 15, 2009

I created this hyperlink function. It links to a1 of sheet 1 to a1 of sheet 2. However, when I click on the a1 cell in sheet 1. an error message appears. I have attached the spreadsheet...

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved