Hell All,
A VBA related question.
I have used the following to save all worksheets as values only - removing formulas etc.
Sub Saveasvalue()
'Updateby Extendoffice
Dim wsh As Worksheet
For Each wsh In ThisWorkbook.Worksheets
wsh.Cells.Copy
wsh.Cells.PasteSpecial...
Hello - is there a way to have a protect sheet with a pivot table auto refresh when the source data is no protected? I am trying to export the pivot table (which is on a protected sheet) to a share folder access. The Pivot table is protect so each employee only sees the information they are...
Hi, I hope someone can help me with this issue.
I need to create a timesheet for staff to complete (see attached)
In cell AI19 where at present the word 'Manager' sits the line manager will change this word to his initials.
After this is entered I would like the cells that correspond to that...
Hi there, long time reader, first time poster.
I am working on a production KPI table and I want to be able to lock all data entered prior to today's date and I would like this protection to be enacted upon saving. I found the code beow and adapted it for my purposes and the dates are in column...
Hi,
Is there a way to lock a cell after data entry, with specific named users having access to write in any empty cell, but not able to overwrite data that has already been entered? I'll explain in more detail below..
I found a method of locking a cell with a password after data entry (i.e. if...
Hello,
I need to create a button that allows a manager to lock all data input, but will then allow other users to add to the sheet below what has already been locked. I know how to set up the button and password, but everything I do to protect the sheet ends up protecting everything --...
Hello,
I have a sheet that automatically updates based on information entered by the user. I need certain cells to be protected, and others not to be. I've tried the following script:
sh2.Range("B2:D2").Locked = False
sh2.Range("C4:D4").Locked = False
sh2.Range("C5:D5").Locked = False...
Hi,
I have a few sheets in a workbook, which have macro`s, formula`s. When someone wants to input information they can do in the main sheets, where there are no formula`s, only input information.
How can I lock or password protect the sheet or stop keying in the sheet, protecting the cells...
I currently use Excel spreadsheet to enter time sheets before I send them off to be processed. I currently use the current week time sheet (adding and deleting employees as needed) - and then after I enter the weekly time I save as the current week but use SAVE as new workbook and clear cells...
Hi
I need a way to lock cells permanently, so not even I can get back into it.
e.g. Lock cells A1 to A10. I can't know the password. I can't alter the VBA code to get back in.
Is this possible?
Cheers!
Currently, my excel has multiple macros that are linked to buttons and another excel embedded. The only purpose of the buttons are to hide/unhide rows. Right now, when I protect my sheet, I check mark the boxes labeled "Select unlocked cells" and "Edit Objects". My macros are set to unlock the...
Hello All,
Can anyone help with auto locking cells when the saved button is pushed.
I used the code from the following thread, but the thread has since gone dark:
http://www.mrexcel.com/forum/excel-questions/686259-auto-lock-cells-after-data-entry-when-file-saved.html
My problem is similar...
Hi,
I would like to protect a particular sheet from editing in various work book files available in particular folder.
In the sheet i need to enable editing option only particular cells which. Rest all i want to protect
For Ex:
File Name: workbook1.xlsx
Sheet Name: sheet1
In a folder i have...
Hello All,
I have placed an ActiveX controls button in a worksheet that will perform a macro. I want to lock the worksheet so that users can only access the cells I designate and also run this macro to validate their data input.
My issue:
When I run the macro with worksheet locked, the macro...
Hello,
I currently use a VBA to auto protect my worksheets upon closing the document. If users do not have a password, they can view the document but, they cannot edit.
I want to allow those who do not have the password to only be able to edit a range of cells. How should I write the code...
Hi I have a locked table in which some columns contain protected cells which always remain locked by the macro. Other columns are not protected to enable users to input data or select drop down menus. I need to change the unprotected cells in a row into protected cells so the macro will then...
Excel Experts,
I need your help in creating a lock for past data for my Inventory List in Excel 2007.
Ideally, I'd like to record macro that will select a list of data that were input before today, and lock these cells.
I know selective cells locked can be done by doing this;
Lock or unlock...
Is it possible to protect different columns with different passwords in the same Sheet?
I am trying to protect different columns with different passwords so different users can only write in their own column?
Many thanks
Hello guys,
I have used below code to delete ranges and create ranges and then protect sheets. For one sheet (Scorer) it is working perfectly but for second sheet (Instructions) it is giving Protection error when I clicked on C2 cell. Please let me know if I am doing anything wrong here?
Sub...
Hi! This very probably has been covered before, but I can't find it.
I have set up a sheet for users to input amounts into. I don't want them to alter any headings or totals.
How do I best 'protect' the cells I don't want to be changed (ie messed up :) )
I get I can protect the whole sheet...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.