Password protection

K

KevinG

Hi,

I'm linking from a summary workbook to several workbooks that are password
protected. Everytime I update links I have to put in the password for each
workbook. Is there anyway I can get round having to type in the password for
each workbook everytime I update links?

Hope you can help

Many thanks

Kevin
 
J

jhyatt

you could use a macro to unlock the sheets or unlock the cells is another
possible solution
 
K

KevinG

Thanks.......

I've had a go at a macro to unlock the sheets but didn't have much luck, do
you have any idea how to go about it?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Repeated Requests for GSuite password when first Accessing Outlook 365 after system start 0
Dumb question alert! What program to use? 0
Linking to Password Protect Workbooks 23
update links to password protected workbooks. 1
Automatically sending multiple parts of text from one word doc to another - is possible. 0
Password Prompt Everytime a Link is Changed 1
Linking Password workbooks 1
Link to a password protected workbook 1

Top