workbooks linked but the source is password protected

August 5, 2019 at 11:25:00
Specs: Windows 10
i have a master wb, sensitive information and password protected, some columns were linked to a all users wb, so users can have access to that info.

when opening all users wb, it ask for the password to update the info (which i can not provide to them). how can i write a macro, so, when opening the file it updates the info without asking to all users wb


See More: workbooks linked but the source is password protected

Reply ↓  Report •

#1
August 8, 2019 at 01:01:10
try asking this under software --> office software

quite a few office profs over there, not so much here

i5-6600K[delid]@4.824GHz Core/4.623GHz cache@1.456v | 2x4GB Crucial-DDR4-2400MHzCL17@3015MHzCL12@1.45v | Sapphire Nitro+ SE RX 590 8GB@1645Mhz core@1.15v/2235MHz@1500MHz timings BiosModded


Reply ↓  Report •
Related Solutions


Ask Question