I have a workbook that works perfectly when saved locally. Even with hidden data and "Protect Sheet" enabled, all is well.
HOWEVER, when I save my workbook to OneDrive, and view the workbook online, all my functions return a #Value error.
My worksheets have Review/Protect Sheet enabled...
I need a macro to run upon opening excel that allows groups to expand and collapse while a sheet is protected. I am using the code below and it works, the issue is that when it re-protects my sheet is it only doing the first two defaulted lock preferences, "Allow all users of this worksheet to...
Is it possible via VBA to prevent a user from protecting a sheet?
Why would I want this?
I have a large spreadsheet that is locked down in every way with password protection at the sheet & workbook level - apart from 3 sheets that the users can do what they want with - they are unprotected...
Here is the situation. I have a workbook that has two sheets, both need to be protected.
On worksheet 1 (name is: Calibration Check Tool) I have a calculate button that I press, which will show pass or fail on worksheet 1. The macro also opens worksheet 2 (name is: Calibration History)...
I Currently trying to write a code that will unlock a locked/procted cell based on data entered in another cell. below is the formula that I currently have.
Private Sub Worksheet_Change(ByVal Target As Range)
IfRange("C10") = "Other" Then
Range("D10").Locked = False...
1) I would like to ask that is there anyway other than macro to protect the sheet with password.
2) Also if i can hide the used formula.
For Example :-
1) I have all my main working data with infor in sheet1 and i am using the data with respective info in sheet2 & sheet3...
Hello all you experts out there,
I have this code and it works for the most part except for the password. The code itself works but when I go to unlock the sheet it doesn't ask me for the password. So it doesn't seem to add it in. Can you please check it out and see what I am missing? THANK YOU...
It was suggested that I post a new topic as I was asking in others not completely related to what I need to accomplish.
I am not very good with VBA, I guess I know enough to get into trouble with it, but not enough to write code from scratch.
My setup is this:
Files are in folders by year and...
For my company, we have Excel pulling from our database to generate reports and it includes some sensitive information (Salary, PII). I want to make it so that when a person opens the shared Excel sheet they hit a button, it checks the username, and unhides sheet2 and sheet3, or only unhide...
I would like to protect shapes so I use the argument DrawingObjects:=True.
However, with this argument set, it's not possible anymore to extend series on cells with a data validation list.
In example, click on cell A1 and autofill the data to cell A10 won't work.
The hand mousepointer appears...
I'm new to this macro. I found following macro to protect sheet in a folder. But somehow it's not working or i am not getting results.
Can you please help where might be wrong.
Const myPassword = "random"
Dim sh As Worksheet
Dim wBk As Workbook
I Need help in to protecting sheets in multiple workbooks in a particular folder.
With a particular password 1st i would like to protect sheets from editing in multiple work books in a folder. I also need to provide a different password to open that work book.
It's like with a password...
Hi all, I'm trying to lock down table edits but need to allow sorting AND executable hyperlinks..
Please help, can't find a solution that works for both.
'Allow Users to Edit Ranges' + all cells locked -> allows sorting but can't click the cells with hyperlinks
'Allow Users to Edit Ranges' +...
I can protect and unprotect sheet using VBA but I can't unprotect using the normal way of excel and I am providing the same password. any help please? below are the codes
ActiveSheet.Unprotect Password = "protect20"
I have two problems which hopefully have the same solution.
I have a template which I have created for a large user group, the template is password protected.
Problem 1. When the user opens the template I have a macro which clears everything in the work sheet so that the user has a...
I have a worksheet that I've created as a Dashboard in Excel 2016. The pivot slicers have shapes around the slicers that make the display more appealing to the end user.
I want the shapes and corresponding code behind the shapes not movable/editable by the end users. This also means I don't...
Sorry to bother,
but does protecting the spreadsheet and locking cells affect the VBA code results? They've been working fine, but now, when I've protected the spreadsheet, I get a runtime error.
The only VBA codes I have are to hide rows when certain fields read certain things. So is the VBA...
I have a document that has 100 sheets (all the same). Each of the sheets has cells that are protected and unprotected cells for folks to enter data. My questions. Is there a way to protect all of the sheets at once, instead of going to each one and protecting it individually.
I have already asked a similar question but I am still not getting the results I had hope for. My goal is to have for instance an entire worksheet that is locked so that other users cannot change anything. However, there will be an exception of cells like C6, C12, C18, etc.. In these particular...