not able to modify

Jmmac04

Board Regular
Joined
Nov 16, 2004
Messages
185
I have a user with several workbooks that he is trying to modify. It has a password to modify on it. He is trying to make changes and puts in the password to modify correctly. When he tries to make a change it tells him he needs to put in the pw so he can modify it. It also says [shared] on top and if I try to unshare it, there is an error that the file is locked even though nobody else has it open and it is on my C: drive. Any ideas where to start? Thanks
:pray:
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.
And.... when I try to close the file it also is saying that the file is locked. There are several macros that run when it is opened, but I am not able to open the macros either.
 
Upvote 0
What is the exact locked error message?

You won't be able to modify the macros while it is shared, so you are correct to unshare it first if you need to.
 
Upvote 0
Thanks Vconfused

The error is:
The file is locked. Try this command again later.
 
Upvote 0

Forum statistics

Threads
1,203,523
Messages
6,055,896
Members
444,832
Latest member
Kauri

We've detected that you are using an adblocker.

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.
Go back
Back
Top