-
If you would like to post, please check out the MrExcel Message Board FAQ and register here.
If you forgot your password, you can reset your password.
lock file
-
B
Macro to unlock and lock file
Hello, I'm trying to create a macro that will unlock and lock a source file saved in a different folder from the file I'm running the macro. It keeps giving me an error and I'm not sure what's referring to. The error says: "<Method 'Range of object'_Global' failed>". Please see screenshot...- Bellatrix461
- Thread
- excel lock file macro password unlock file vba
- Replies: 4
- Forum: Excel Questions
-
G
Linked excel spreadsheet getting locked and so cant be updated
Excel 2010 I have created 2 connections to 2 excel spreadsheets on a shared drive that contain the data I need to reference. I created the links using connections button in the data tab and then I have created 2 tables in 2 seperate sheets using the get external data, exsiting connections...- gcdrake
- Thread
- connections lock file
- Replies: 0
- Forum: Excel Questions
-
V
file locked
Hi All, Is there any way I can restric the access to the shared workbook? Here is my problem: We have a shared workbook which is used by many persons for updates. now every now and then we get the message that file is locked. Sometimes it gives the message that someone has locked the file...- vijayendra.shukla
- Thread
- lock file
- Replies: 1
- Forum: Excel Questions
Watch MrExcel Video
This Week's Hot Topics
-
Excel VBA Parse Column A into multiple columns help but with conditions
- Started by BalloutMoe
- Replies: 57
Hello, I have a TXT file that gets imported in excel and it always ends up in column A. I am trying to split the data up however. The middle... -
Data with Different score
- Started by sksanjeev786
- Replies: 30
Hi Team, I have a Wave 2 and Wave 1 data and need different only if we have any letter in Column A and B in Column D for example i have kept data... -
Looping a macro through all visible sheets?
- Started by GlennJ
- Replies: 29
I have a macro that does exactly what I need. I just need it to do the same thing to all sheets. Any help would be appreciated. [CODE=vba] Sub... -
Loop through Column, looking for an array of values, If NOT found, delete entire row
- Started by blbat
- Replies: 29
So I tried to modify some good code from Joe4, but ran into some walls. I'm trying to modify his working loop to cycle through Column "D", find... -
VBA to extract values starting with specific character
- Started by sncb
- Replies: 21
Hi all, I paste two cells of data into A1 and B1 with different formats and spacing like below and I need to extract only those values that start... -
macro/vba fix for not a blank, blank in Go To Special
- Started by LorettaAlsop
- Replies: 20
I am writing vba code (thru using macros) to format a ws. In a portion of the formatting I identify the blank cells and replace them with the cell...
