In keeping with their monopoly on code, Microsoft has, of course, locked all of the included XL add-ins (the code part).
I was interested in looking at how some of these add-ins functioned, seems like it could be fairly educational.
how to unlock the modules that come with XL's add-ins?
Excel 2007 - need to adjust protected view settings but the protected view tab is missing from my Trust Centre settings - have the following tabs - trusted publisher / location, add-ins, activeX, macro, message bar, external content and privacy options. Document is a revenue authority download and without being able to adjust the protected view settings, can't input data.
View 3 Replies View RelatedI try to move the cursor using the keyboard arrows it stays on the cell it is on and the whole spreadsheet page moves across the screen in the direction of the arrow. So how do I restore cursor movement to the arrows.
View 3 Replies View RelatedI have a spreasheet with one locked collum that I don't want to be edited. Is there any way of filtering while this collum is locked? It seems to be that once it locks the collum it also locks the filters?
View 6 Replies View Relatedhow to lock a formula in a cell, protect the sheet but still allow it to recalculate when new data is entered in a unlocked cell that feeds the formula? I am using Excel 2003.
View 5 Replies View Relatedkindly help in jumping locked cell in a proteced worksheet..
View 9 Replies View RelatedSub PastSpec()
If Selection.Locked = True Then Exit Sub
On Error GoTo ErrHan
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
ErrHan:
Exit Sub
End Sub
I recorded part of it and adapted it afterwards. You will notice I have a line to check for locked cells, this does its job if the cell selected is locked. However if the cell selected is unlocked and the cell below is locked the code still excutes and pastes.
I recently added two excel files to my startup, I receive the file in use error that the personal.xls is locked for editing box when the second file starts to execute. I can open them separately using their icons with no problem, what's the problem with opening them using the startup function. XP professional version 2002 SP2.
View 9 Replies View RelatedIn the Properties for every Text box I have on my forms it's not letting me change any of the colours but I can change the fonts etc, I'm using Excel 2003.
View 3 Replies View RelatedI have one spreadsheet that is locked and I cannot modify, with a button I want to press from a fresh new one that I have created.
The first one is private and cannot modify it.
Now, what code should I use in mine so I can "click" the button of the other one when I press it?
Using vba, I want to be able to tell if the vba code is locked. Using the below function I can tell most of the time. The only problem is if the " Lock project for viewing" isn't checked the below function will say it isn't protected. Is there a way to tell if it is protected even if they didn't check "Lock project for viewing".
Function ProtectedVBProject(ByVal wb As Workbook) As Boolean
' returns TRUE if the VB project in the active document is protected
Dim VBC As Integer
VBC = -1
On Error Resume Next
VBC = wb.VBProject.VBComponents.Count
On Error Goto 0
If VBC = -1 Then
ProtectedVBProject = True
Else
ProtectedVBProject = False
End If
End Function
Any way to make it so that a cell can remain locked but be able to click a hyperlink? I need the cell to remained locked so nobody can alter the hyperlink name and value but I would like users to be able to click it and have it open in their browser.
View 9 Replies View RelatedI have an application that I made for a company. the editing is locked on each tab except for the blanks for people to either check mark a box or fill in the space provided for an answer to each question. There are around 30 tabs. Sometimes i open already completed applications since most of the answerer will be the same. My question is. is there a way to select say 6 tabs and clear out all the data that someone had typed in (check marks, answers in space provided?)
View 4 Replies View RelatedI have created a spreadsheet that will be viewed/used by various users (read only as I have protected the sheet except from three fields), although I would like to give them the ability to copy the contents of a specific cell that is protected.
I have tried to give them the ability to select the locked cells and then copy, but that means that the formulae in the cell is copied as well.
how I can let people copy a locked cell without the formulae?
On an excel document that was originally formatted as a number and then locked, somehow users have changed the formatting to a date. I think it is an accident, but I can't figure out how they are doing it. I have several data files on a server where several offices have access to them to input data and somehow formatting gets changed sometimes, even when locked.
View 3 Replies View RelatedI have worksheet that contain values in column E and G and the total in column K. E and G are unlocked for manual input and column K contains the formula for the total and is locked. From time to time a certain row will not be applicable and before I started locking the cells in column K i would just put "not applicable". Now that it's lock I can't do that. My only option now is to put O in column E and G but I would rather put "not applicable" in column K. Is there a way around this. I was thinking of something along the line of a macro that would unlock the worksheet input the text and re lock it. The macro would have to lunch when a locked cell is selected or have a button that would launch the macro an would prompt for which cell the text would be entered. Is this possible.
View 7 Replies View RelatedSome how my spread sheet became shared and has been locked. so when I went to use my VBA to unlock the sheet i found my project locked as well and no way to get to properties to try and unlock.
View 3 Replies View RelatedI'm using three different workbooks for the macro I've designed. The macro works exactly as I planned it would, but I'm getting a curious side-effect of running the macro. I have over 5,000 workbooks that I need to open, unprotect, change (mostly by copy/paste), and reprotect. It's a fairly straight forward macro, but it is my first, and I must be overlooking something. When the macro is complete, cells that were not modified via the macro in any planned/anticipated way are being unlocked. This has left me puzzled and frustrated. The files are opened, unprotected, the cells are copied over as planned, reprotected, and closed/saved. Everything works perfectly, but the cells in parts of the workbook (Filename) (which were locked before the macro ran) have been unlocked and are no longer protected when the workbook is reprotected. Again, these cells were not within the ranges modified, and I'd rather not have to format every cell in every one of the 5 sheets of (Filename) to be locked.
File names are:
"Finished Goods Inventory TREE (ToDMSI).xls" (alias: Workfile - sheet providing file path to be updated)
"Random_workbook_selected_from_previous_filename.xls" (alias: FileName - the copy-to file being updated)
"MACRO TEST BOM Master.xls" (the copy-from file always open)
Comma Delimited table layout in "Finished Goods Inventory TREE (ToDMSI).xls":
Col A, Col B, Col C, Col D
Customer ID,Item Code,File Name, Directory
4FRE01,4FRE01-0001,4FRE01-0001.xls,4FRONT
Here's the
Public FileName
Public Workfile
Public ItemCode
Public CustCode
Sub OpenBOMSeq()
how to create two buttons so that I can have a data entry specific protection and then a lock all button. Here's the link to the thread:
http://www.excelforum.com/excel-prog...-a-button.html
And here's the code I'm currently using:
I've created quite a few workbook/worksheets in excel 2007 compatibility mode that are data entry intensive. When protecting these worksheets, you have the option of allowing the user to "select locked cells". I invariably uncheck this option because the user doesn't need to interact with these cells.
However, several of my users are running Excel 2000 and the same option is not available when one protects a worksheet in Excel 2000. Is there a way to do that in VBA for these Excel 2000 users such that when they click on a locked cell, the cursor will not respond to that cell?
I have a spreadsheet on lets say 10 columns, now col 1 and 9 are locked so they cant be selected. Col 2-8 can be sorted by selecting them, but information in col 10 does not sort.
Question is there a way of connecting the cells in col 10 to the cell in lets say col 2, so thay when you sort the rows and cols between 2 and 8, the cells on col 10 are sorted as well As i have noticed you cant sort two differenr selections...???
I have a simple macro that's in my default Excel startup file (Personal.xlsb - located in the folder C:Documents and SettingsUsernameApplication DataMicrosoftExcelXLSTART).
The problem is when I try to open two instances of Excel (not create a new workbook). I get the error message "Personal.XLSB is locked for editing."
I've look at other threads that talk about adding the macro as an "Add-In" (Personal.xlsb and multiple Excel's), BUT my problem is that I want to assign the macro a keyboard shoutcut (currently set to ctrl + shift + v).
I don't know of a way to assign an add-in macro a keyboard shortcut.
I want to insert a text box into a line graph. I want the box locked onto a data point in this graph. The problem I am having is the graph is updated daily with more data so the point moves so I have to drag the box daily. Is there a way to fix this so it works automatically?
View 1 Replies View RelatedI am getting a message, the Excel file i am opening (xlsm) is locked for editing by 'another user'. But, NOT SO, of course; i am the only user logged in to this PC, and there is no network access. I quit Excel and verified that i see no Excel processes running. But, when i try to open the file, i still get the "locked by 'another user'" message, and at this point can only open read-only. I looked in the folder the file is in and do not see any of those ~ files or anything else suspicious.
So, what do i do? How do i "unlock"? How can i open this file once again to make modifications to it?
I inherited a spreadsheet from a recently let go co-worker. This spreadsheet has a lot of important financial data on it, so I really need to get into the spreadsheet. we contacted the former employee and he said he forgot the password. Is there any work around to get into the sheet?
View 2 Replies View RelatedI want to create a completely uneditable locked workbook.
I know how to do the simple stuff like unlocking cells for the purpose of entering data values and locking the rest of the sheet.
What I want to do is also lock out users from changing headers, footers, etc.
Ultimately, what I'd like is, when the file is launched by the user, all that is displayed is the sheet with no toolbars and no menu bar. Finally, the last thing, is to have 'print' button (with obvious macro built in).
Simply put, this is an electronic version of a paper worksheet, so no saving is required either.
I have a sheet with 56 columns with locked columns every 6 or 7 columns.
The rest of the sheet is unlocked for data entry.
What I would like the cursor to do is when it reaches a locked column, drop to next row instead of moving to the next free cell in the row.
Data entry is from left to right first six columns starting at C8 to H8
Next is L8 To Q8 and so on for 56 columns
When cursor reaches H8 I want it to drop to C9 or whatever column I'm entering into Q8 to L9
I have a template that I have hidden the formulas but allowed editing. Is it possible to create a pop up box for the end user to use to edit a cell with the hidden formula? This is a budget template with already set up formulas but the end user needs to be able to make edits but the end users are beginner excel users and if they double click on the cell the formula will automatically delete leaving the cell blank. I need a way around this so they cant view the formula but only change the data if they really mean to change it.
View 3 Replies View RelatedIs there an easy way to show/return any Unprotected Cells on a Protected Worksheet?
View 8 Replies View RelatedI have created a simple excel document with
Sub randomnumbers()
Range("B1").Formula = "=randbetween(1,100)"
Range("B1").Value = Range("B1").Value
End Sub
There is a button that i click and it creates a random number to cell 'B1'. it works fine, but i need to lock the document so that the user can only access one cell... 'A1' when i lock the document, and i click the button, it gives me a '400' error. i think it is because the button points to a locked cell.