Hi I am having problems inserting Hyperlinks in unlocked cells on protected worksheets.
With the help of this forum I have been successfully using the code below to auto filter
However, I have noticed after this code is run, I am unable to insert a hyperlink in the unlocked cells. I have...
I have a couple of macro's that need to unlocked specified sheet protections, run the code, then reinstate the protections as they were before. At the moment I can only reinstate it for the whole sheet which impacts my slicers and future use of the sheet.
I just want to go back and fix all my sheets as the number of rogue unlocked cells is becoming large, (mostly my rushing things over the year with a copy here paste there)
I'd just like a macro that Selects all the unlocked cells on a sheet, so I can save time checking each...
I found a code from the Internet and built it into my sheet, but there are a few small issues :confused:
I want to highlight in my sheet each active line, right when i click on a cell he should highlight the line.
At the same time, the existing conditional formatting...
Is there a way to keep a range of hyperlinks working on a protected sheet? I only want to select unlocked cells for protection please. This sheet is for filling out data so I want to keep the cursor in the unlocked region.
I am using the following VBA:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Target.Address(0, 0) = "B14" Then
Cancel = True
Rows("15:38").Hidden = Not Rows("15:38").Hidden
The codes works well until i come to...
Hi, after searching the web and testing VBA codes, I've become stuck...
I have a Cell Range - E8:J27:
where all cells have a fill color of RED,
and can change to either WHITE or BLACK
which is determined by conditional formatting.
For the desired outcome I am not sure if the cell range...
I have an Excel/VBA app that consistently hangs up for 30-60 seconds when I tab past the last unlocked cell on the sheet.
Here are some of the details:
- the behaviour is consistent; when the sheet is locked there are a few unlocked cells for data entry that I can tab through. when I...
On page 732 of MrExcel's book "Learn Excel 2007-2010" it explains how to add a printable image to a sheet. At the bottom of the page is a "Gotcha: It is now difficult to select a cell with the mouse" ... and it is. The book goes on to say "To avoid this, you click outside the picture and then...
Hello Excel Experts,
I have a worksheet that is protected by password using VB. The cells in sheets some cells are locked and some are unlocked. This seem to work fine until I close the worksheet. When I reopen the sheet the cells are unlocked automatically but sheet is protected.
Thanks in advance.
Hi, I have a worksheet that I purposely protect and allow users to edit numerous unlocked cells within the protected sheet. However, I would like the user to be able to lock his/her own cells also. Within the protected worksheet they have access to unlocked cells. Is there a way without them...
I have a workbook which i use for technical analysis. It works perfectly in Excel 2003, 2007 and 2010. However when i use it in 2013 if I try and type in an unprotected cell Excel treats it as protected, even though Properties clearly show Unprotected. This happens only after I have used...
Hi, I have an unlocked cell that I want users to manually input parameters BUT not to be able to cutcopy from anywhere (and most certainly NOT from other non excel formats that they may have kept a record of said parameter)
Any ideas? I gather private function should do this but Ive been lead...
how to lock excel from dragging in unlocked cell in locked excel sheet?
In Column A is unlocked and in B locked Cell, if dragged unlocked cells then formula in Column B changes (as formula depends on cell value in column A) to no of cells that...
Hi All, I have a bit of a head scratcher. I distributed an Excel file for use in the field, with the worksheets locked to protect the formulas. This file is being used by probably dozens of people without problem - except for two persons. One has the German OS on his computer, the other the...
I have a single sheet .xlsm which I wish to distribute... where users can ONLY modify a few specific cells... but they cannot access the formulae or macros which operate on the cells.
I have followed all "instructions" as found via Microsoft Office etc. but always end up with either...
I have a Combo Box (Form Control, not ActiveX) which is Unlocked. When I protect the worksheet it returns this error when I click the box:
"The cell or chart you are trying to change is protected and therefore read-only.
To modify a protected cell or chart, first remove protection using the...